DSXchange

Hi,
How can we say a job is CPU limited or I/O limited or Memory limited while we attempt to tune a job? How to monitor the usage of CPU, I/O and Memory? Datastage v8 have lot of performance reporting but v7.5 don't have such sophistication? What would be the possible way to collect the usage information?

Many Thanks
MSR

EtlStats is the begining of this. You need all the columns for parallel jobs. You also need the OS stats during your job runs.

When you get version 8 there are inbuilt performance analysis and resource estimation tools.