We have
various data warehouses hosted on AIX/Linux/Unix operating systems. DataStage Director is one of the ETL monitoring & scheduling tool used in
numerous data warehouses. In case of ETL job failures we need to login to DataStage
Director and check the log for error messages. The ETL job logs can tend to
span into several pages with various types of informative messages. Usually we
need to locate the error message under ‘Fatal’ message type. Doing this task by
searching the DataStage log manually can be very time consuming and tiring.
This shell
script facilitates the user to access the error messages from the ease of
the Linux screen. The script also has
facility to email the filtered log messages to the user’s mail box.
Ø Accept
jobname and other parameters while script execution.
Ø Establish
proper environment settings for local DataStage use
Ø Locate
event ids for fatal errors in the ETL joblog.
Ø Extract
detail log for fatal errors
Ø Mail
the filtered job log with exact fatal error message to the user.
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/
