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