Hi All,
I have to check the datastage Log Reports. But all the log reports were cleared. So I am unable to fetch log report for a particular job.
Is there any way we can see the old log reports on DataStage jobs.
Thanks in advance.
Sandeep.
How To Find Cleared Log Reports
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to restore the backed up hashed file that is the log for that job, but not over the top of the hashed file for the existing job. For example, you could rename the hashed file during the restore process. After that, you can create a VOC pointer to the restored hashed file, with field #3 referring to D_RT_LOG (the file dictionary for all logs), and process that hashed file using DataStage BASIC.
If you want to use Director, then it becomes more complex and dangerous (to the existing log for this job). I won't go into details of this just yet.
If you want to use Director, then it becomes more complex and dangerous (to the existing log for this job). I won't go into details of this just yet.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RT_LOG has basically a surrogate key. There is a field which stores the starting key for each run. It is stored in what is called a multivalued field. So it is not simple to extract the starting number and only list records which are between an old number and the next job run. I would try SQL if I was you. You could probably figure it out.
Mamu Kim