Status column in DataStage Director

lordlebu · Post by **lordlebu** » Wed Jun 20, 2012 3:44 am

Hi All,

I wanted to now how the status column of datastage director is defined or how it is derived.

Regards,
Lebu

chulett · Post by **chulett** » Wed Jun 20, 2012 6:48 am

It reads the job's current status which is stored in the RT_STATUSnnn table.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 20, 2012 4:42 pm

There is a separate RT_STATUSnnn table for each job. The information is not summarised anywhere. The nnn is the unique job number allocated by DataStage when the job is created and which is recorded as JOBNO in the DS_JOBS table (whose key is NAME, the job name).

The status of each active or hybrid stage is also stored in the RT_STATUSnnn table for the job. This information is viewable in the Monitor view of Director.

Status is stored as a TinyInt; it can be decoded using mnemonics that can be found in the JOBCONROL.H header file. For example 0 is "running", 1 is "finished OK", 2 is "finished (see log)", 3 is "aborted", 21 is "has been reset", etc. From memory there are about 12 possible status values.