Wanted to know about the way Log files are maintained in DB2 similar to Oracle where we have Metadata table which stores the Log entries. Is there anything similar in DB2 which stores the Log files....
Any info on this will be very helpful..
Log Info
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
All the log files are stored in the project directory as RT_LogXXXX where XXXX is the Job Number. You can get the Job Number from DS_JOBS, but these files cannot be read as normal file.
You have to write a utility on your own, to convert those entries to a normal file. Search on this forum , you will get lot of posts on converting the log file.
You have to write a utility on your own, to convert those entries to a normal file. Search on this forum , you will get lot of posts on converting the log file.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are NO log files in DataStage. Logged events are stored in database tables (hashed files) called RT_LOGnnn, where nnn is the job number. You can archive the events from them by a number of techniques, all of which can be found via a Search of the forum.
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.