Page 1 of 1

Datastage environment audit

Posted: Tue Feb 14, 2012 12:50 pm
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