IBM DataStage Job Status Codes

IBM DataStage Job Status Codes 

This post will help you to understand dataStage job status log  values seen during execution, running, completion or failure of job. DK® 

Steps to find out status codes of datastage job from backend/command line : DK®

cd  /opt/IBM/InformationServer/Server/DSEngine/bin/

dsjob  -jobinfo {ProjectName} {JobName}

Below mentioned values can be used when designing “job sequencers” when defining triggers or nested conditions. Values are also helpful when using DataStage "dsjob" utility from the operating system command line. DK®

Most Common Job status codes : We can see these status codes very frequently. DK®

0 "Running"

1 "Finished"

2 "Finished (see log)"

3 "Aborted"

Runnable Job Status (Do something) – DK®

 You can execute the jobs without reset, if your current job status is from below mentioned list. DK®

1 "Finished"

2 "Finished (see log)"

9 "Has been reset"

11 "Validated OK"

12 "Validated (see log)"

21 "Has been reset"

99 "Compiled"

NOT Runnable Job Status (reset job) – DK®

You have to stop/reset the jobs first, if your current job status is from below mentioned list.

0 "Running"

3 "Aborted"

8 "Failed validation"

13 "Failed validation"

96 "Aborted"

97 "Stopped"

98 "Not Compiled"