Running datastage job through Unix shell script
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
Running datastage job through Unix shell script
Hi All,
I am trying to trigger the datastage jobs through unix shell script & untill yesterday all the jobs were running fine but today when i tried to execute the same job through same shell script i am getting error.
This is the error messge i am receiving after executing the script:
Status code = -99 DSJE_REPERROR
The job sqRunMainFlow is completed with status : 255
Any help is appreciated.
I am trying to trigger the datastage jobs through unix shell script & untill yesterday all the jobs were running fine but today when i tried to execute the same job through same shell script i am getting error.
This is the error messge i am receiving after executing the script:
Status code = -99 DSJE_REPERROR
The job sqRunMainFlow is completed with status : 255
Any help is appreciated.
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
Hi ArndW,
Thanks for the reply.
In the morning when i reset the job this is what the log is saying:
From previous run
DataStage Job 95 Phantom 8630
DataStage Phantom Finished.
Also, This is the command i am using for running the job:
${DSHOME}/bin/dsjob -run -wait -jobstatus -param pEmailLst=${EmailLst} -param pCountryCode=${Cntry} ${DS_PROJ_ODS} sqRunMainFlow
Thanks for the reply.
In the morning when i reset the job this is what the log is saying:
From previous run
DataStage Job 95 Phantom 8630
DataStage Phantom Finished.
Also, This is the command i am using for running the job:
${DSHOME}/bin/dsjob -run -wait -jobstatus -param pEmailLst=${EmailLst} -param pCountryCode=${Cntry} ${DS_PROJ_ODS} sqRunMainFlow
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As you can run the job from the Client, the Problem should be in your Unix Shell Script that you used to call the DS Job.sourabhverma wrote:I would like to make one more point here that when i try to run the same job through datastage client, it is working properly.
Check the error message in your Script!!!
RAJ
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
I have not made any changes in the script as well as in the datastage job. when i run the job thru script, nothing is available in the director because the script not at all triggeres the job.
These are the logs of the yesterday`s completed run :
sqRunMainFlow..JobControl (@Coordinator): Summary of sequence run
06:03:03: Sequence started
06:03:03: sqTopLevelBatch (JOB sqTopLevelBatch) started
06:36:55: sqTopLevelBatch (JOB sqTopLevelBatch) finished, status=2 [Finished with warnings]
06:36:55: sqRunInvoicingSeq (JOB sqRunInvoicingSeq) started
06:36:56: ExecRunServiusageSH (COMMAND sh) started
16:18:19: ExecRunServiusageSH finished, reply=0
16:18:19: sqRunInvoicingSeq (JOB sqRunInvoicingSeq) finished, status=1 [Finished OK]
16:18:19: Sequence finished OK
These are the logs of the yesterday`s completed run :
sqRunMainFlow..JobControl (@Coordinator): Summary of sequence run
06:03:03: Sequence started
06:03:03: sqTopLevelBatch (JOB sqTopLevelBatch) started
06:36:55: sqTopLevelBatch (JOB sqTopLevelBatch) finished, status=2 [Finished with warnings]
06:36:55: sqRunInvoicingSeq (JOB sqRunInvoicingSeq) started
06:36:56: ExecRunServiusageSH (COMMAND sh) started
16:18:19: ExecRunServiusageSH finished, reply=0
16:18:19: sqRunInvoicingSeq (JOB sqRunInvoicingSeq) finished, status=1 [Finished OK]
16:18:19: Sequence finished OK
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What does this long-running shell script do? Could it return an error?06:36:56: ExecRunServiusageSH (COMMAND sh) started
16:18:19: ExecRunServiusageSH finished, reply=0
Last edited by ArndW on Tue Feb 09, 2010 10:45 am, edited 1 time in total.
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
Hi Ray,
I did not make any change into the script & DS job, yesterday it ran fine. I tried to check the variables also but they are pretty much fine, i mean all the variables are acepting values properly but script gives the error while trying to trigger the datastage sequencer job.
I did not make any change into the script & DS job, yesterday it ran fine. I tried to check the variables also but they are pretty much fine, i mean all the variables are acepting values properly but script gives the error while trying to trigger the datastage sequencer job.
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am