Page 1 of 1

DataStage Upgradation issue

Posted: Thu Nov 19, 2009 9:37 am
by Nareshkurra
Hi all,

We have upgraded our Datastage(7.5.1 to 7.5.3) and Oracle(9i to 10g) in our current environment.

The issue here is few of the DS jobs which used to run just for 1 min in our previous environment are now running for long time and they are not even getting completed. We are killing them manually from DS director.

Can any one please let us know why is this happening?

Posted: Thu Nov 19, 2009 9:51 am
by Sainath.Srinivasan
Check the director log and monitor to see what operation is being performed when the system is slow.

Run the operating system admin commands to check process and space.

Posted: Thu Nov 19, 2009 12:17 pm
by Nareshkurra
Hi,

I have verified the space on my OS, everything looks fine.

Posted: Thu Nov 19, 2009 12:26 pm
by vinnz
Is the problem only with jobs loading to Oracle? Do DataStage and Oracle reside on the same box? Do you see the same issue with jobs that do not connect to the database?