datstage import problems
Moderators: chulett, rschirm, roy
datstage import problems
When i am trying to import a dsx file into a project by the name MDS_SYSTEST0_R44 using the datastage manager i get this error message.Did anyone get this kind of problem before.
Error calling subroutine: DSR_WHEREUSED (Action=3); check DataStage is set up correctly in project MDS_SYSTEST0_R44
(The connection is broken (81002))
Error calling subroutine: DSR_WHEREUSED (Action=3); check DataStage is set up correctly in project MDS_SYSTEST0_R44
(The connection is broken (81002))
Re: datstage import problems
Can be several things, seen it on several occasions:
A few things to try (in order):
* Reboot the system your Datastage client is running on and try it again;
* Bounce the Datastage Server and do a cleanup of the projects;
* Check whether no-one erased part of your DataStage Server installation.
Regards,
Ogmios
A few things to try (in order):
* Reboot the system your Datastage client is running on and try it again;
* Bounce the Datastage Server and do a cleanup of the projects;
* Check whether no-one erased part of your DataStage Server installation.
Regards,
Ogmios
Re: datstage import problems
How do i clean up.
The way i know is to use DS TOOLS.Do you have any other suggestions.
Thanks!
The way i know is to use DS TOOLS.Do you have any other suggestions.
Thanks!
Re: datstage import problems
I usually have everyone log out and do cleanup via DataStage administrator but via DS TOOLS it should also work. In any case try bouncing (stopping/starting) Datastage server.deep wrote:How do i clean up.
The way i know is to use DS TOOLS.Do you have any other suggestions.
Thanks!
Ogmios
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The two most common causes are inactivity timeout and network failure between client and server machine.
Inactivity timeout is easily addressed in Administrator client (set a long inactivity timeout, or "do not timeout"); alternatively don't be idle for longer than specified. You might also check the timeout for the dscs service in the dsrpcservices file.
Inactivity timeout is easily addressed in Administrator client (set a long inactivity timeout, or "do not timeout"); alternatively don't be idle for longer than specified. You might also check the timeout for the dscs service in the dsrpcservices file.
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.
We received this error on numerous occasions due to a lack of resources. DataStage and SQL server were running on the same machine, the administrator of the box being a SQL fan, treated DS like an orphan and had it share the operating system's cpu while allocating all the other cpu's to SQL. When we allocated another CPU to DS it worked like a charm and we never had any problems again.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The lack of resources possibly contributed to a timeout.morneh wrote:We received this error on numerous occasions due to a lack of resources. DataStage and SQL server were running on the same machine, the administrator of the box being a SQL fan, treated DS like an orphan and had it share the operating system's cpu while allocating all the other cpu's to SQL. When we allocated another CPU to DS it worked like a charm and we never had any problems again.
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.
Strange, normally either the "Do not timeout" is switched on (and the "seconds" are greyed out) or the "Do not timeout" is switched off (and the "seconds" are changeable).
Are you sure you're logged on as DataStage administrator?
Were you in the meantime already able to import something, or is your problem occurring consistently?
Regards,
Ogmios
Are you sure you're logged on as DataStage administrator?
Were you in the meantime already able to import something, or is your problem occurring consistently?
Regards,
Ogmios
Then you are not logged on as the Administrator. Pre-7, you would need to be either 'root' or 'dsadm' to have the permissions to make that change. From what I understand, that restriction has been 'relaxed' with 7, but you still need Adminstrator privledges to change the Inactivity Timeout - and then you need to bounce the server.deep wrote:In my Administrator window,the inactivity timeout is GREY an the do not timeout is also grey. I dont have anything to click on.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers