Hi
I'm looking at recovery techniques for cases such as DB failure, a DS crash and so on. I intend to write an informational message to the log file intermittently to reflect the progress which a job has made.
Can anybody tell me if I can then access the log file outside of Director (ie. is it written as a txt file somewhere?), so that I might run a script over the file to determine which data had been processed and which remained to be done at the point of failure?
Thanks
ff
Running scripts on log files
Moderators: chulett, rschirm, roy
Hello ff
You can indeed get to the log-info of a job. It does require some knowledge about the log-file though.
Each job you have in your project has a set of files created by Datastage.
The files are hash-files type 30 (dynamic) and the names are :
DS_TEMPnn, RT_CONFIGnn, RT_LOGnn and RT_STATUSnn where nn is a sequential number starting with 1 for the first job in your project.
There are also some other files but they are not important for your task.
You can use the LIST command (as in LIST RT_LOGnn) to get to the records. You can also create another Datastage job that reads the logfile of another job. You can get to the filelayout by using the command LIST DICT RT_LOGnn.
The RT_STATUSnn reflects what you would normally see in the monitor.
I hope this helps.
B. Sorensen,
Optico IT ApS
You can indeed get to the log-info of a job. It does require some knowledge about the log-file though.
Each job you have in your project has a set of files created by Datastage.
The files are hash-files type 30 (dynamic) and the names are :
DS_TEMPnn, RT_CONFIGnn, RT_LOGnn and RT_STATUSnn where nn is a sequential number starting with 1 for the first job in your project.
There are also some other files but they are not important for your task.
You can use the LIST command (as in LIST RT_LOGnn) to get to the records. You can also create another Datastage job that reads the logfile of another job. You can get to the filelayout by using the command LIST DICT RT_LOGnn.
The RT_STATUSnn reflects what you would normally see in the monitor.
I hope this helps.
B. Sorensen,
Optico IT ApS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: