Collecting Performance Metrics

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
muralisankarr
Premium Member
Premium Member
Posts: 83
Joined: Tue Oct 28, 2008 1:55 am
Location: Chennai

Collecting Performance Metrics

Post by muralisankarr »

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
The minute you start talking about what you're going to do if you lose, you have lost
Top
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Contact kduke

Post by kduke »

EtlStats is the begining of this. You need all the columns for parallel jobs. You also need the OS stats during your job runs.
Mamu Kim
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

When you get version 8 there are inbuilt performance analysis and resource estimation tools.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”