Question & Answer
Question
How do I generate job report for a DataStage job?
Answer
In Designer Client, open any job you want to get report for, then
- Click Job Properties icon to open the job properties window
- Under 'General' tab, select 'DSJobReport' in the drop-down list under 'After-job-subroutine'
- On the right side specify Report type by entering value 0,1 or 2 under 'Input Value' field depending on the level of detail you need to get for the job. Optionally, you can specify the directory where to direct the report to be generated.
For example:
Specifying '1:/tmp/' without quotes will generate a job report with name starting with JobName_Date_Timestamp.txt under /tmp/ directory
More information can be found in IBM WebSphere DataStage and QualityStage Designer Client Guide and online InfoCenter under Before- and after-job routines section.
This is a sample output with Report type 1:
$ more UlimitTest_20130225_165937.txt
**************************************************
STATUS REPORT FOR JOB: UlimitTest
Generated: 2013-02-25 16:59:40
Job start time=2013-02-25 16:59:37
Job end time=2013-02-25 16:59:40
Job elapsed time=00:00:03
Job status=1 (Finished OK)
Stage: External_Source_0, rows input
Stage start time=2013-02-25 16:59:39, end time=2013-02-25
16:59:39, elapse
d=00:00:00
Link: DSLink2, 18 rows
Stage: Peek_1, 18 rows input
Stage start time=2013-02-25 16:59:39, end time=2013-02-25
16:59:39, elapse
d=00:00:00
Link: DSLink2, 18 rows
Note: A report for each run is generated with the current time stamp so each new run of the job will generate a new report.
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21627331