Shelll Script for row count

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

kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

There is a video on how to install it. The DSJobReportDbDriver job runs a job called DSJobReportDb. This job does all the work. You can change this to meet your needs. It writes row counts to hashed files and tables. You can delete one or the other just to get it working. DSJobReportDbDriver has a parameter for job name. Use ALL to get row counts for every job in the project.

There are lots of posts about these jobs. Search for them.
Mamu Kim
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

EtlGetRowCountsFromLog is designed to get row counts from the log files for previous job runs. It works like DSJobReportDb in where it writes the results.
Mamu Kim
Post Reply