help in DSJOB command
Moderators: chulett, rschirm, roy
help in DSJOB command
HI,
i am trying to run a job uing dsjob command.
but it throws failed to open project.
ihave executed ,
eadm@bbmkscrtst02::/opt/app/dstage/DataStage752/Ascential/DataStage/DSEngine/bin>dsjob -server bbmkscrtst02 -user eadm -password pass-word -run padev rowcount
ERROR: Failed to open project
Status code = 81016
Where padev is my project name and rowcount is the job i want to run.
while exeutibng the hostname command i am getting bbmkscrtst02.
In some other posts, they mentioned about signon file.
where (in which path) i can find that signon file?
I have tried ../dsenv and exexuted the dsjob command.
but i have got the same error again.
Whats the mistake in that command i have executed?
Where i can check the list of the projects which reside under bbmkscrtst02?
is there any directory in $DSHOME to check teh names of the projects?
thanks
i am trying to run a job uing dsjob command.
but it throws failed to open project.
ihave executed ,
eadm@bbmkscrtst02::/opt/app/dstage/DataStage752/Ascential/DataStage/DSEngine/bin>dsjob -server bbmkscrtst02 -user eadm -password pass-word -run padev rowcount
ERROR: Failed to open project
Status code = 81016
Where padev is my project name and rowcount is the job i want to run.
while exeutibng the hostname command i am getting bbmkscrtst02.
In some other posts, they mentioned about signon file.
where (in which path) i can find that signon file?
I have tried ../dsenv and exexuted the dsjob command.
but i have got the same error again.
Whats the mistake in that command i have executed?
Where i can check the list of the projects which reside under bbmkscrtst02?
is there any directory in $DSHOME to check teh names of the projects?
thanks
pandeeswaran
hi i want to run a below logic in a script using dsjob command.
i have a job which has to run 100 times regartdless of the return code of the run.
the second run has to start afer the first one is over.
I have tried with the below script
but i am getting the error;
Status code = -10 DSJE_JOBLOCKED
ERROR: Failed to lock job
Status code = -10 DSJE_JOBLOCKED
ERROR: Failed to lock job
May i know whats wrong in the script?
can anyone help me?
thanks
i have a job which has to run 100 times regartdless of the return code of the run.
the second run has to start afer the first one is over.
I have tried with the below script
Code: Select all
i=0
While [ i -le 100 ]
do
dsjob command----
if [ $? -eq 0 ]
then
i = `expr $i + 1 `
fi
done
Status code = -10 DSJE_JOBLOCKED
ERROR: Failed to lock job
Status code = -10 DSJE_JOBLOCKED
ERROR: Failed to lock job
May i know whats wrong in the script?
can anyone help me?
thanks
pandeeswaran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's nothing wrong in the script except that you don't wait for the job to finish before attempting to restart it (there's no evidence that you're using $i as an invocation ID). It is not possible to run a job that is already running.
So, what are you trying to accomplish here?
So, what are you trying to accomplish here?
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,
And one more doubt is , i am triggering a sequence using dsjob command
the sequence aborts after some 4 th job in the sequence.
Again if i run the dsjob comand it throws DSJE_BADSTATE Error STATUS CODE=-2.
My requirement is ,while running the dsjob comand again it should start from the 4 th job and not from the beginnig of the sequence,
Provided checkpoint is enabled in the sequence.
How to achieve this ?
thanks
And one more doubt is , i am triggering a sequence using dsjob command
the sequence aborts after some 4 th job in the sequence.
Again if i run the dsjob comand it throws DSJE_BADSTATE Error STATUS CODE=-2.
My requirement is ,while running the dsjob comand again it should start from the 4 th job and not from the beginnig of the sequence,
Provided checkpoint is enabled in the sequence.
How to achieve this ?
thanks
pandeeswaran
If you are using KornShell, you can wait for the job to finish by using the wait command.
For a sequence, set the sequence as adding checkpoints to be restartable, and in your Job Activity set the Execution Action to Reset if Required, Then Run.
Code: Select all
dsjob blah blah &
wait
Hi,
i have tried the below script:
i=0
While [ i -le 100 ]
do
dsjob command----
Wait
if [ $? -eq 0 ]
then
i = `expr $i + 1 `
fi
done
Now i am getting:
Status code = 0
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Status code = 0
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
2) i have changed the script like below:
i=0
While [ i -le 100 ]
do
dsjob command----
wait
i = `expr $i + 1 `
done
Status code = 0
./rowcount.sh[11]: i: not found
rror running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Status code = 0
./rowcount.sh[11]: i: not found
we dont know how long the job take to finish?
So how we can check whether the job is finished or running?
thanks
i have tried the below script:
i=0
While [ i -le 100 ]
do
dsjob command----
Wait
if [ $? -eq 0 ]
then
i = `expr $i + 1 `
fi
done
Now i am getting:
Status code = 0
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Status code = 0
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[13]: i: not found
Error running job
2) i have changed the script like below:
i=0
While [ i -le 100 ]
do
dsjob command----
wait
i = `expr $i + 1 `
done
Status code = 0
./rowcount.sh[11]: i: not found
rror running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.sh[11]: i: not found
Status code = 0
./rowcount.sh[11]: i: not found
we dont know how long the job take to finish?
So how we can check whether the job is finished or running?
thanks
pandeeswaran
hi,
i am still getting the same error..
My script is like this:
#!/bin/ksh
i=0
while [ $i -le 100 ]
do
dsjob -server bbmkscrtst02:31539 -user etladm -password dev-1234 -run ODSDEV rowcount &
wait
i = `expr $i + 1`
done
Status code = 0
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Status code = 0
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
i am still getting the same error..
My script is like this:
#!/bin/ksh
i=0
while [ $i -le 100 ]
do
dsjob -server bbmkscrtst02:31539 -user etladm -password dev-1234 -run ODSDEV rowcount &
wait
i = `expr $i + 1`
done
Status code = 0
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Status code = 0
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
rowcount.ksh: i: not found
pandeeswaran
i want to find the alternative for start/end loop stages via script.
After adding -wait option also, i am getting the same error:
Status code = 0
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Status code = 0
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Status code = 0
./rowcount.ksh[11]: i: not found
^Z[1] + Stopped (SIGTSTP) ./rowcount.ksh
etladm@bbmkscrtst02::/work/cr
After adding -wait option also, i am getting the same error:
Status code = 0
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Status code = 0
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Error running job
Status code = -2 DSJE_BADSTATE
./rowcount.ksh[11]: i: not found
Status code = 0
./rowcount.ksh[11]: i: not found
^Z[1] + Stopped (SIGTSTP) ./rowcount.ksh
etladm@bbmkscrtst02::/work/cr
pandeeswaran