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"