DataStage Upgradation issue

Nareshkurra · Post by **Nareshkurra** » Thu Nov 19, 2009 9:37 am

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?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Nov 19, 2009 9:51 am

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.

Nareshkurra · Post by **Nareshkurra** » Thu Nov 19, 2009 12:17 pm

Hi,

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

vinnz · Post by **vinnz** » Thu Nov 19, 2009 12:26 pm

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?