Listing Passive Stages in a Job

deepticr · Post by **deepticr** » Mon Aug 08, 2011 1:35 am

Hi,

I'm trying to list out the passive stages in a DataStage Parallel Job [DataStage v8.1] using the DSGetJobInfo function.

#### Server Routine Code as below ####
$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle = DSAttachJob(JobName,DSJ.ERRFATAL)

Ans = DSGetJobInfo(JobHandle,DSJ.STAGELIST2)

### End of Code ######

This routine doesn't list out the Oracle Enterprise Stage as a passive stage. Instead it shows up as an active stage. In the repository under Stage Types -> Parallel -> Database, I checked the properties of the Oracle Enterprise stage and found that it is check marked as a Passive stage. In that case why should my routine list it as an active component? Could anyone help?

Thanks
Deepti

chulett · Post by **chulett** » Mon Aug 08, 2011 7:26 am

Seems like a bug to me. Are you up-to-date on fixpacks? Have you checked with your official support provider?

deepticr · Post by **deepticr** » Tue Oct 04, 2011 4:50 am

I checked with the IBM team and they agree that the rutine doesn't work as expected. And I also shared the routine code. They provided a workaround for my code piece. And also conformed that there is no correction for this even in v8.5

chulett · Post by **chulett** » Tue Oct 04, 2011 6:37 am

Care to share the workaround?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 04, 2011 2:47 pm

This "issue" has been around since version 1.0, in which the ORABULK stage was an active stage because they felt the need to support after-job subroutine through which sqlldr could be invoked with user-supplied options. I guess it's just continued through.