How to get job log for InfoSphere DataStage job outside of Director and how to search for job log messages whithin many jobs

 

https://www.ibm.com/support/pages/how-get-job-log-infosphere-datastage-job-outside-director-and-how-search-job-log-messages-whithin-many-jobs

How to get job log for InfoSphere DataStage job outside of Director and how to search for job log messages whithin many jobs?
Question & Answer
Question
How to obtain job log messages for troubleshooting when it is not possible to do it with Director due to some issues? How to search for error/warning messages that occured in jobs in a big DataStage project with thousands of jobs?
Answer
The dsjob command can be used to retrieve and display log entries of a job:
https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.cliapi.ref.doc/topics/r_dsvjbref_Accessing_Log_Files.html

You can use the Operations Console to view messages from job runs:
https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.monitor.doc/topics/opcmessages.html?lang=en

Alternatively to the dsjob command, the DSODB database - table JobRunLog can be used to get log details of a job.
The operations database stores information about all job runs on the systems being monitored. Run SQL queries against the operations database to extract monitoring data.
Extracting monitoring data from the operations database:
https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.monitor.doc/topics/queryodb.html
JobRunLog table:
https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.monitor.ref.doc/topics/jobrunlogtable.html?lang=en
Operations database schema reference:
https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.monitor.ref.doc/topics/opsdb.html?lang=en

Using above information you can create scripts to obtain required details.