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
Performance degradation upgrading DataStage release
Moderators: chulett, rschirm, roy
This shouldnt be just due to the DS upgrade. Check whether the table has any lock, and the job might be waiting for the lock to get relased.
Why cant you check the disk spcace?
What do you mean by central memory? Is it temp dirictory? If so what stops you to check the avaiability of space?
Why cant you check the disk spcace?
What do you mean by central memory? Is it temp dirictory? If so what stops you to check the avaiability of space?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
I can't check the disk space or the list of processes in running mode during the execution of my job (I mean ram memory for central one) because I can't access the Server machine as administrator. The server is located in Losanna (Swizzerland) and I'm in Rome. We access only the directory containing data and I have no tools to use for capturing other informations. I think that DS upgrade is not responsable of perfomance degradation too but I have to be sure. Anyway thank you for the answer.kumar_s wrote:This shouldnt be just due to the DS upgrade. Check whether the table has any lock, and the job might be waiting for the lock to get relased.
Why cant you check the disk spcace?
What do you mean by central memory? Is it temp dirictory? If so what stops you to check the avaiability of space?
Have a nice day
Umberto
You can also find some DOS based freewares http://www.pc-tools.net/dos/dosutils/, which can help you.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
I'll do that. Thank you againkumar_s wrote:You can also find some DOS based freewares http://www.pc-tools.net/dos/dosutils/, which can help you.