Hi,
i am using the dsjob command to run my job as below:
dsjob -run -jobstatus projectname jobname
When ever my job completes with warnings, i am getting the status code =2 and when ever it fails with Fatal Errors, i am getting the status code=2.
According to IBM documentation, i should get status_code=3 when Job finished a normal run with a fatal error.
Is there a way to achieve this?
Thanks,
Mohsin Khan
Datastage job Status Code=2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
With parallel jobs not all "Fatal" errors are fatal (cause abort). You can get red icons in the log but the job status is "Finished (see log)". I don't agree with that, but it does sometimes occur.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
Actually i created the test job, in the output sequential file, i have given the path name incorrectly where the file gets created. SO my job aborted with errors and there are Fatal Errors:
Example:
seq_output,0: Unable to open XXX/XXX/XXX.txt: No such file or directory.
buffer(0),1: Fatal Error: APT_BufferOperator::writeAllData() write failed.
This gives me the jobstatus of :2 in stead of 3.
Actually i created the test job, in the output sequential file, i have given the path name incorrectly where the file gets created. SO my job aborted with errors and there are Fatal Errors:
Example:
seq_output,0: Unable to open XXX/XXX/XXX.txt: No such file or directory.
buffer(0),1: Fatal Error: APT_BufferOperator::writeAllData() write failed.
This gives me the jobstatus of :2 in stead of 3.
Mohsin Khan
Datastage Consultant
Datastage Consultant
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
And they say this issue was fixed in 9.1 and is there in 9.1 fix list here as JR41781
Are you on 9.1 or 9.1.2?
Are you on 9.1 or 9.1.2?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Please be more precise - we know you have fatal errors in the log but what's important to note here is the actual status of the job shown in the Director. Ray has already noted that the job may still end up in a "Finished (see log)" status rather than "Aborted" in that case.
Also note that the fix posted in this particular case is to no longer consider that problem "fatal" but rather simply a warning. So the ending job status is actually correct!
Also note that the fix posted in this particular case is to no longer consider that problem "fatal" but rather simply a warning. So the ending job status is actually correct!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers