Performance degradation upgrading DataStage release
Posted: Fri Aug 11, 2006 2:26 am
Hi
we are upgrading DataStage Server from release 7.1 to 7.5.2 one and it works all fine but sometimes the duration of some Jobs is different. For example a Job Server who read data from an Oracle table and write them onto an hashed file in the previous release run in 20 minutes now in...24 hours. I think it depends on unavailable resources such as disk spaces (files fragmentantion????) or peraphs central memory but I can't see the disks situations or the list of proccesses on the server meanwhile the Job is running.
Any suggestions????
Thank you very much
Umberto
we are upgrading DataStage Server from release 7.1 to 7.5.2 one and it works all fine but sometimes the duration of some Jobs is different. For example a Job Server who read data from an Oracle table and write them onto an hashed file in the previous release run in 20 minutes now in...24 hours. I think it depends on unavailable resources such as disk spaces (files fragmentantion????) or peraphs central memory but I can't see the disks situations or the list of proccesses on the server meanwhile the Job is running.
Any suggestions????
Thank you very much
Umberto