how to create a customized report

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
boppanakrishna
Participant
Posts: 106
Joined: Thu Jul 27, 2006 10:05 pm
Location: Mumbai

how to create a customized report

Post by boppanakrishna »

hi all,
how to create and generate a customized report after the job has run successfully

Thanks in Advance
Boppana Ramakrishna
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

Using -
1. One after job routine that runs when job finishes successfully and uses basic functions to scan the log and write the log summary in file.
2. Using a shell script that checks if job executed successfully or not and if yes, generate the report. You can use the dsjob command for this.
Regards,
S. Kirtikumar.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

What is the customization you are expecting?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
venkat_kp
Charter Member
Charter Member
Posts: 33
Joined: Sun May 07, 2006 8:16 am

Re: how to create a customized report

Post by venkat_kp »

boppanakrishna wrote:hi all,
how to create and generate a customized report after the job has run successfully

Thanks in Advance
Boppana Ramakrishna
I would like to add 2 more qtns to this post.

1. How can we get all the job log entries including Score & Osh, errors etc from the Director in to one single file? I am aware of the dsjob, does it give the score & generated osh, not sure.

2. When we enable APT_PERFORMANCE_DATA it writes into a file in XML format. Which style sheet we need to use and what is the procedure?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

dsjob can dump the entire contents of the job log. Therefore, for example, if you had APT_DUMP_SCORE set to True, there will be a score event (or two - one for licensing) in the job log. Other environment variables (in the Reporting section) control what other information is logged.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply