Hi,
I have a particular px job. I have set the multiple instance property for the job. I have 2 seperate shell scripts invoking the same job with different parameters. I want to run the jobs in parallel through these 2 shell scripts but i see that one of the jobs fails where as the other one runs fine.
I call the datastage job in the sehll script as follows.
using dsjob function
which takes the parameters as follows
dsjob -run -mode NORAML <parameter> -warn <warning limit> -jobstatus <project name> <job name>
Is there any way I can set any of the parameters so that I can run the jobs in parallel.
regards,
varsha
Multiple Instance of a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
dsjob -run -mode NORMAL -param1=<parameter1> -param2=<parameter2> -warn <warning limit> -jobstatus <project name> <job name>.<invocationID>
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.
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
Hi Varsha
While calling multiple instance enabled jobs ( or sequences) through shell scripts, you have to mention instance name after the job name as shown in post above.
One more imp thing, for a multi instance enabled job seqeunces, all jobs called in that sequence should be multiple instance enabled and in the job activities, proper instance name should specified.
Manier times in our projects, we are setting these instances to job parameters so that each time a unique instances created as per the change in job parameter.
Send a mail if you need anything else in this regard as we are doing it here!!!
While calling multiple instance enabled jobs ( or sequences) through shell scripts, you have to mention instance name after the job name as shown in post above.
One more imp thing, for a multi instance enabled job seqeunces, all jobs called in that sequence should be multiple instance enabled and in the job activities, proper instance name should specified.
Manier times in our projects, we are setting these instances to job parameters so that each time a unique instances created as per the change in job parameter.
Send a mail if you need anything else in this regard as we are doing it here!!!
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 48
- Joined: Thu Mar 11, 2004 10:32 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Explain WHY you have this doubt.
Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed?
Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed?
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.
-
- Participant
- Posts: 48
- Joined: Thu Mar 11, 2004 10:32 pm
The job works fine, I am in the process of running the job with live data from production, on an average the lookup stage processss around 169219 reocrds, my worry is that if multiple instances of a job run, and if lookup stage is used, it should not result in the jobs to fail. I am uisng the null handling and the reject monitering in case of lookups. Once I do the performance testing, may be I would be in a better position on this.ray.wurlod wrote:Explain WHY you have this doubt.
Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed?