Collecting job statistics

ankita · Post by **ankita** » Thu Jul 12, 2007 3:20 pm

Hi All,
I am using DSJobReport to get the job statistics in xml file format.One job will be designed to read all such xml files and populate into a table.Since for each job level of details will vary, is there any way to find out the master list of attributes that can be generated through this report ?
Say, one xml file will have Job level attributes, Parameter details, ComponeneSet details etc. I need to list all the possible levels and attributes and their datatype as defined by DataStage.

Please suggest !

Thanks,
Ankita

ray.wurlod · Post by **ray.wurlod** » Thu Jul 12, 2007 3:48 pm

It's not possible with DSJobReport. What you get is what you get. If you want something else, investigate ETLstats or search the forum for DIY techniques.

ankita · Post by **ankita** » Fri Jul 13, 2007 9:52 am

Thanks for the reply ! Can you please help me to understand the meaning/significance of following attributes as shown in job report ?

- Job WaveNo="1"
- StageStatus="10"

Is there any documentation where I can find these details ?
Also what is 'DIY technique' ?

chulett · Post by **chulett** » Fri Jul 13, 2007 9:59 am

DIY = Do It Yourself.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 13, 2007 2:54 pm

Wave number is a number used internally by DataStage to identify a unique instance of a job run. You don't need to interact with it.

Stage status is the status of an active stage (for example starting, waiting, running, finished), as reported in the Monitor view in Director. As far as I am aware there is no list for decoding these codes.

ankita · Post by **ankita** » Fri Jul 13, 2007 4:24 pm

Thanks Ray!