Page 1 of 1

How to collect the Performance Statistics of the JOB

Posted: Wed Aug 13, 2008 1:58 am
by sreedharmsc
How to to collect the Performance Statistics of the JOB after each Execution/run

Posted: Wed Aug 13, 2008 2:06 am
by dspxlearn
sreedharmsc,

You can call the DSJOB commands in your script which actullay runs your datastage job. Take the first and last evenId of the job and then add 1 to get all your job parameters by using the 'lognewest' option with DSJOB.

Posted: Wed Aug 13, 2008 3:04 am
by ray.wurlod
Buy MetaStage and have them collected automatically. (Note that MetaStage ceases to exist with effect from version 8.0).

Download ETLstats from Kim Duke's website which is a set of tools that will gather these statistics and put them wherever you like.

Don't re-invent the wheel!