Error calling job through sequencer
Moderators: chulett, rschirm, roy
Error calling job through sequencer
I have 10 sequencers calling same job.when i tried to run all the sequencers parallely I am getting the following error
Controller problem: Error calling DSAttachJob(commonjob.14)
(DSOpenJob) Cannot get shared access to executable file for job commonjob
Thanks in advance
Controller problem: Error calling DSAttachJob(commonjob.14)
(DSOpenJob) Cannot get shared access to executable file for job commonjob
Thanks in advance
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
Re: Error calling job through sequencer
bgs wrote:I have 10 sequencers calling same job.when i tried to run all the sequencers parallely I am getting the following error
Controller problem: Error calling DSAttachJob(commonjob.14)
(DSOpenJob) Cannot get shared access to executable file for job commonjob
Thanks in advance
This is a known error in DataStage. When ever there is a call to a job from sequence , it will attach the job handle to run the Job.
In your case as you are running 10 sequences for the same job, each sequence will try to do the DSAttachJob.............Where some will succeed and some will abort with the above error.
What actually is your requirement ??? Y are you calling the same job from 10 sequences???? I hope you are running all atonce.......Why are you doing it???
we get files from different sources.so as soon as we receive the file the job will be triggered.so if we get 10 files at a time then all the 10 sequencers will be triggered at same time.
And in the common job multiple instance flag is set,so I think it should not be a problem when this job is called by 10 sequencers parallely.
And in the common job multiple instance flag is set,so I think it should not be a problem when this job is called by 10 sequencers parallely.
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
bgs wrote:we get files from different sources.so as soon as we receive the file the job will be triggered.so if we get 10 files at a time then all the 10 sequencers will be triggered at same time.
And in the common job multiple instance flag is set,so I think it should not be a problem when this job is called by 10 sequencers parallely.
Though you have enabled the Multiple instance Job, the concept of multiple instance is ...........
The Calling sequence will attach the handle to the called job. This has to happen sequentialllyy...........not really sequential..but there is a limit.
When 3-5 sequences call the Job ...it will be successful. When you are trying to run more than that there is always a chance for this error to occure, because when one is trying to get the handle other would have already got the handle and it is not yet released. IT is all related to the timing.
Do try checking the multiple instance option and give a an invocation id with some parameter , so that when ever you try to attach the job with different sequencer you will have an instance of the job created.
I am not sure if what you are saying falls true always, because I run my audit job parallal with each and every job and at one point I have more than 10 jobs running, I never had these problem ..though!
I am not sure if what you are saying falls true always, because I run my audit job parallal with each and every job and at one point I have more than 10 jobs running, I never had these problem ..though!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The limit is initially imposed by the physical size limit on the job log (2GB by default). More instances = more log entries. It's also affected by how many events are logged by each instance.
One could, of course, convert the log file to 64-bit addressing. Then the limit is probably constrained by disk space, since the theoretical upper limit on log file size is then of the order of 19 million TB. Do you have that much free disk space?!
One could, of course, convert the log file to 64-bit addressing. Then the limit is probably constrained by disk space, since the theoretical upper limit on log file size is then of the order of 19 million TB. Do you have that much free disk space?!
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.