We call Datastage Job through a unix shell.
Script:
dsjob -server $DWSERVER -user $DWUSER -password $DWPWD -run -param file=$feed_file -jobstatus $DSPROJ Batch::BOEMALLOCProcess
exitcode=$?
if (( exitcode == 1 )) then
echo "Job completed successfully"
elif (( exitcode == 2 )) then
print "Job completed with warnings"
else
echo "Job Failed" $exitcode
exit $exitcode
fi
Output :
If the feed file just contains small amount of data i.e. datastage job run for less than an hour the status is is Job Completed successfully.
We have a feed file that has approximately 5 million records which takes approximately 2 hours to be processed.
datstage job has completed successfully and without any warnings but dsjob doesn't return specific exit code we get the following message :
Missing StringID[2045]
The script hangs. If I do a ptree on the process it shows it is still waiting for the datastage job to be completed.
27505 /usr/openwin/bin/xterm -sb -ls -display 10.30.120.24:0.0
27642 -ksh
18931 /bin/ksh em_alloc_plan_fact_process.sh em_alloc_plan sap_planind
7651 dsjob -server wil1asff1 -user dstage -password dstage1 -run -param file=sap_plan
Can somebody help me as to why this is happening ?
Missing StringID[2045]
Moderators: chulett, rschirm, roy
-
shradha_shetty
- Participant
- Posts: 2
- Joined: Tue Oct 19, 2004 10:38 am
Re: Missing StringID
It was timeout parameter. We had the timeout parameter in DSAdmin set as 3600 seconds (1 hr). Changed that to never time out and it works fine. :D
shradha_shetty wrote:We call Datastage Job through a unix shell.
Script:
dsjob -server $DWSERVER -user $DWUSER -password $DWPWD -run -param file=$feed_file -jobstatus $DSPROJ Batch::BOEMALLOCProcess
exitcode=$?
if (( exitcode == 1 )) then
echo "Job completed successfully"
elif (( exitcode == 2 )) then
print "Job completed with warnings"
else
echo "Job Failed" $exitcode
exit $exitcode
fi
Output :
If the feed file just contains small amount of data i.e. datastage job run for less than an hour the status is is Job Completed successfully.
We have a feed file that has approximately 5 million records which takes approximately 2 hours to be processed.
datstage job has completed successfully and without any warnings but dsjob doesn't return specific exit code we get the following message :
Missing StringID[2045]
The script hangs. If I do a ptree on the process it shows it is still waiting for the datastage job to be completed.
27505 /usr/openwin/bin/xterm -sb -ls -display 10.30.120.24:0.0
27642 -ksh
18931 /bin/ksh em_alloc_plan_fact_process.sh em_alloc_plan sap_planind
7651 dsjob -server wil1asff1 -user dstage -password dstage1 -run -param file=sap_plan
Can somebody help me as to why this is happening ?