performance statistics

via · Post by **via** » Tue Mar 20, 2007 8:52 am

Hi,
We are using datastage v8.0.1 on AIX.The requirement is to collect job performance statistics like when job started, finished; how many rows processed finally;how many rows rejected; cpu utilisation.....

Can anybody help me to catch those details for a datastage job! when we generate a report on a job, it gives all details except what we required!
I appreciate any help in this.
Thanks.

DSguru2B · Post by **DSguru2B** » Tue Mar 20, 2007 8:55 am

If the dsjob command is the same for 8.0 as well then you should look at dsjob -report and get all the information from there. Go through the manuals, there should be more in-built reporting abilities of 8.0

via · Post by **via** » Tue Mar 20, 2007 9:03 am

Thanks Brian for your prompt response.
I am novice in datastage.Where to use that Dsjob command.Is it by adding execute command activity at the end in job sequence? or is there any location where datastage engine automatically stores all job details?

Regards

DSguru2B · Post by **DSguru2B** » Tue Mar 20, 2007 9:06 am

Read about dsjob command in developers guide under command line. Its basically run at the unix level. dsjob -report will give a report of the job that will contain the start time, end time, the elapsed time, job status etc.

via · Post by **via** » Thu Mar 29, 2007 10:00 am

Thanks sree

ray.wurlod · Post by **ray.wurlod** » Thu Mar 29, 2007 3:57 pm

You should be able to report these directly using Analyis Server.

via · Post by **via** » Tue Apr 03, 2007 7:59 am

Hi all,
The issue solved.In DS v8.0.1, when we check the option catch operational meta data in DS ADMINISTRATOR, When ever a job runs, operational meta data is stored in xml files.We can access those XML files.It got all information related job run..

Thanks for all responses.

kduke · Post by **kduke** » Tue Apr 03, 2007 9:23 pm

Sounds like you still need EtlStats to load this into a table. Not good.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 11:04 pm

It's not stored in XML files; it's stored in the common repository. XML is merely one way to report.

kduke · Post by **kduke** » Wed Apr 04, 2007 6:21 am

I hope so.