Hi All,
We have an occational problem where a batch job tries to attach a job (in compiled status) and fails on trying to attach it. The message in the log looks like:
Batch::P390LDAP..JobControl (JobControl): Batch::P390LDAP failed to attach job P390LDAP
This problem has also happened to us for other batch jobs attaching other jobs as well. Does anyone have any ideas as to what can cause a job that is in compiled status to still fail to attach?
We are on NT4, DataStage 5.1.
Thanks,
Scott
Failed to attach job problem
Failed to attach job problem
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Failed to attach job problem
This is a wild guess, but it sounds like a resource
issue on your NT class server. There's a finite
number of dynamic hash files that can be open at any
given time, and when you run out unexplainable errors
occur when trying to start jobs. Do you notice this
when there's a bunch of jobs running concurently?
There is a setting in the uvconfig file called
T30FILES. You may want to investigate increasing that
value.
Good luck!
-Ken
--- Scott Brooks wrote:
> Hi All,
>
> We have an occational problem where a batch job
> tries to attach a job (in compiled status) and fails
> on trying to attach it. The message in the log
> looks like:
>
> Batch::P390LDAP..JobControl (JobControl):
> Batch::P390LDAP failed to attach job P390LDAP
>
> This problem has also happened to us for other batch
> jobs attaching other jobs as well. Does anyone have
> any ideas as to what can cause a job that is in
> compiled status to still fail to attach?
>
> We are on NT4, DataStage 5.1.
>
> Thanks,
>
> Scott
>
>
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
issue on your NT class server. There's a finite
number of dynamic hash files that can be open at any
given time, and when you run out unexplainable errors
occur when trying to start jobs. Do you notice this
when there's a bunch of jobs running concurently?
There is a setting in the uvconfig file called
T30FILES. You may want to investigate increasing that
value.
Good luck!
-Ken
--- Scott Brooks wrote:
> Hi All,
>
> We have an occational problem where a batch job
> tries to attach a job (in compiled status) and fails
> on trying to attach it. The message in the log
> looks like:
>
> Batch::P390LDAP..JobControl (JobControl):
> Batch::P390LDAP failed to attach job P390LDAP
>
> This problem has also happened to us for other batch
> jobs attaching other jobs as well. Does anyone have
> any ideas as to what can cause a job that is in
> compiled status to still fail to attach?
>
> We are on NT4, DataStage 5.1.
>
> Thanks,
>
> Scott
>
>
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Failed to attach job problem
>>> kcbland_2000@yahoo.com 01/12/2004 12:40:27 PM
This is a wild guess, but it sounds like a resource issue on your NT class server. There's a finite
number of dynamic hash files that can be open at any given time, and when you run out unexplainable errors occur when trying to start jobs. Do you notice this when there's a bunch of jobs running concurently? >>>
Thanks for your idea, Ken.
We indeed have a number of jobs running at that time of the problem. So, I think your idea is worth pursuing.
Our current uvconfig has:
# T30FILE - specifies the number of
# dynamic files that may be opened.
# Used to allocate shared memory
# concurrency control headers.
T30FILE 200
I hope you don't mind a few question details:
Do you have a recommended number?
Do I just change this value in Notepad, or do I go through the DataStage Administrator or something?
Do I have to stop and start the DataStage services to get the change in place?
Thanks,
Scott
This is a wild guess, but it sounds like a resource issue on your NT class server. There's a finite
number of dynamic hash files that can be open at any given time, and when you run out unexplainable errors occur when trying to start jobs. Do you notice this when there's a bunch of jobs running concurently? >>>
Thanks for your idea, Ken.
We indeed have a number of jobs running at that time of the problem. So, I think your idea is worth pursuing.
Our current uvconfig has:
# T30FILE - specifies the number of
# dynamic files that may be opened.
# Used to allocate shared memory
# concurrency control headers.
T30FILE 200
I hope you don't mind a few question details:
Do you have a recommended number?
Do I just change this value in Notepad, or do I go through the DataStage Administrator or something?
Do I have to stop and start the DataStage services to get the change in place?
Thanks,
Scott
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Failed to attach job problem
Up your T30FILES to 500 and then you have to compile
the change in.
>From the server, go the engine directory using a DOS
prompt. Type in bin\uvregen and it should compile the
change. You'll have to recycle the services.
Since I do a lot of highly instantiated job designs,
and a lot of hash file staging, I typically have
clients up this number pretty high. If you figure
each job has 3 dynamic hash files open during runtime
(log, config, status), then add in however many the
jobs on average use, 200 hundred seems like a small
number.
Anyway, take a shot, see if it helps. It shouldn't
hurt anything.
-Ken
--- Scott Brooks wrote:
> >>> kcbland_2000@yahoo.com 01/12/2004 12:40:27 PM
> This is a wild guess, but it sounds like a resource
> issue on your NT class server. There's a finite
> number of dynamic hash files that can be open at any
> given time, and when you run out unexplainable
> errors occur when trying to start jobs. Do you
> notice this when there's a bunch of jobs running
> concurently? >>>
>
> Thanks for your idea, Ken.
>
> We indeed have a number of jobs running at that time
> of the problem. So, I think your idea is worth
> pursuing.
>
> Our current uvconfig has:
>
> # T30FILE - specifies the number of
> # dynamic files that may be opened.
> # Used to allocate shared memory
> # concurrency control headers.
> T30FILE 200
>
> I hope you don't mind a few question details:
>
> Do you have a recommended number?
> Do I just change this value in Notepad, or do I go
> through the DataStage Administrator or something?
> Do I have to stop and start the DataStage services
> to get the change in place?
>
> Thanks,
>
> Scott
>
>
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
the change in.
>From the server, go the engine directory using a DOS
prompt. Type in bin\uvregen and it should compile the
change. You'll have to recycle the services.
Since I do a lot of highly instantiated job designs,
and a lot of hash file staging, I typically have
clients up this number pretty high. If you figure
each job has 3 dynamic hash files open during runtime
(log, config, status), then add in however many the
jobs on average use, 200 hundred seems like a small
number.
Anyway, take a shot, see if it helps. It shouldn't
hurt anything.
-Ken
--- Scott Brooks wrote:
> >>> kcbland_2000@yahoo.com 01/12/2004 12:40:27 PM
> This is a wild guess, but it sounds like a resource
> issue on your NT class server. There's a finite
> number of dynamic hash files that can be open at any
> given time, and when you run out unexplainable
> errors occur when trying to start jobs. Do you
> notice this when there's a bunch of jobs running
> concurently? >>>
>
> Thanks for your idea, Ken.
>
> We indeed have a number of jobs running at that time
> of the problem. So, I think your idea is worth
> pursuing.
>
> Our current uvconfig has:
>
> # T30FILE - specifies the number of
> # dynamic files that may be opened.
> # Used to allocate shared memory
> # concurrency control headers.
> T30FILE 200
>
> I hope you don't mind a few question details:
>
> Do you have a recommended number?
> Do I just change this value in Notepad, or do I go
> through the DataStage Administrator or something?
> Do I have to stop and start the DataStage services
> to get the change in place?
>
> Thanks,
>
> Scott
>
>
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Failed to attach job problem
Sorry, missed your question about editing the uvconfig
file. Notepad is fine, Wordpad, edit, vi, whatever.
It's a text configuration file.
-Ken
--- Kenneth Bland wrote:
> Up your T30FILES to 500 and then you have to compile
> the change in.
>
> From the server, go the engine directory using a DOS
> prompt. Type in bin\uvregen and it should compile
> the
> change. You'll have to recycle the services.
>
> Since I do a lot of highly instantiated job designs,
> and a lot of hash file staging, I typically have
> clients up this number pretty high. If you figure
> each job has 3 dynamic hash files open during
> runtime
> (log, config, status), then add in however many the
> jobs on average use, 200 hundred seems like a small
> number.
>
> Anyway, take a shot, see if it helps. It shouldn't
> hurt anything.
>
> -Ken
>
>
> --- Scott Brooks wrote:
> > >>> kcbland_2000@yahoo.com 01/12/2004 12:40:27 PM
> > This is a wild guess, but it sounds like a
> resource
> > issue on your NT class server. There's a finite
> > number of dynamic hash files that can be open at
> any
> > given time, and when you run out unexplainable
> > errors occur when trying to start jobs. Do you
> > notice this when there's a bunch of jobs running
> > concurently? >>>
> >
> > Thanks for your idea, Ken.
> >
> > We indeed have a number of jobs running at that
> time
> > of the problem. So, I think your idea is worth
> > pursuing.
> >
> > Our current uvconfig has:
> >
> > # T30FILE - specifies the number of
> > # dynamic files that may be opened.
> > # Used to allocate shared memory
> > # concurrency control headers.
> > T30FILE 200
> >
> > I hope you don't mind a few question details:
> >
> > Do you have a recommended number?
> > Do I just change this value in Notepad, or do I go
> > through the DataStage Administrator or something?
>
> > Do I have to stop and start the DataStage services
> > to get the change in place?
> >
> > Thanks,
> >
> > Scott
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
file. Notepad is fine, Wordpad, edit, vi, whatever.
It's a text configuration file.
-Ken
--- Kenneth Bland wrote:
> Up your T30FILES to 500 and then you have to compile
> the change in.
>
> From the server, go the engine directory using a DOS
> prompt. Type in bin\uvregen and it should compile
> the
> change. You'll have to recycle the services.
>
> Since I do a lot of highly instantiated job designs,
> and a lot of hash file staging, I typically have
> clients up this number pretty high. If you figure
> each job has 3 dynamic hash files open during
> runtime
> (log, config, status), then add in however many the
> jobs on average use, 200 hundred seems like a small
> number.
>
> Anyway, take a shot, see if it helps. It shouldn't
> hurt anything.
>
> -Ken
>
>
> --- Scott Brooks wrote:
> > >>> kcbland_2000@yahoo.com 01/12/2004 12:40:27 PM
> > This is a wild guess, but it sounds like a
> resource
> > issue on your NT class server. There's a finite
> > number of dynamic hash files that can be open at
> any
> > given time, and when you run out unexplainable
> > errors occur when trying to start jobs. Do you
> > notice this when there's a bunch of jobs running
> > concurently? >>>
> >
> > Thanks for your idea, Ken.
> >
> > We indeed have a number of jobs running at that
> time
> > of the problem. So, I think your idea is worth
> > pursuing.
> >
> > Our current uvconfig has:
> >
> > # T30FILE - specifies the number of
> > # dynamic files that may be opened.
> > # Used to allocate shared memory
> > # concurrency control headers.
> > T30FILE 200
> >
> > I hope you don't mind a few question details:
> >
> > Do you have a recommended number?
> > Do I just change this value in Notepad, or do I go
> > through the DataStage Administrator or something?
>
> > Do I have to stop and start the DataStage services
> > to get the change in place?
> >
> > Thanks,
> >
> > Scott
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Failed to attach job problem
>>> kcbland_2000@yahoo.com 01/13/2004 12:32:39 AM >>>
Sorry, missed your question about editing the uvconfig
file. Notepad is fine, Wordpad, edit, vi, whatever.
It's a text configuration file.
Sorry, missed your question about editing the uvconfig
file. Notepad is fine, Wordpad, edit, vi, whatever.
It's a text configuration file.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.