DSXchange

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 ?

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 ?