Datastage environment audit

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
dsuser_cai
Premium Member
Premium Member
Posts: 151
Joined: Fri Feb 13, 2009 4:19 pm

Datastage environment audit

Post by dsuser_cai »

Hi

We have multiple projects running in our datastage environment. Also we have both 7.5. & 8.0.1.

We need to implement an audit mechanism to monitor the datastage environment.

We are thinking about the following points to capture and implement. Could anybody suggest us a more points or is there some thing that needs to be added or modified. Your suggestions are needed.

Capture the following:
1) ETL job name
2) ETL Start and end time
3) ETL Elapsed time
4) Extract record count
5) Load /update record count
6) Rejected record count
7) ETL run date
8) Job status
9) capture how many times a job was in a day
10) capture job log files.

Shell script
1) file management - archiving old files
2) FTP files between servers
3) zipping and unzipping files
4) job restartability
5) dataset sir cleanup
6) kill zombie process at Eod
Thanks
Karthick
Post Reply