Log Info

kris_r · Post by **kris_r** » Mon Nov 13, 2006 2:10 am

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..

kumar_s · Post by **kumar_s** » Mon Nov 13, 2006 3:39 am

How do you load data. In most of the database, the load will be optionally logged. You can collect it in a file as well.

kris_r · Post by **kris_r** » Mon Nov 13, 2006 4:17 am

I am getting the Warnings in the Log, but is there any file in which it is also logged which I can access.
I know I can get the log by using DSGetLogSummary function, but that will consume a lot of memory.
I want to know if there is any place where the log will get stored....

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Nov 13, 2006 5:08 am

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.

chulett · Post by **chulett** » Mon Nov 13, 2006 8:22 am

I'm confused... are you looking for information on DataStage logs or something DB2 related as you stated in your initial post?

If the latter, suggest you go and have a chat with your DBAs.

kris_r · Post by **kris_r** » Mon Nov 13, 2006 9:59 pm

Yes, I am referring to Datastage Logs. The Logs which appear as warning in director should be stored somewhere on the datastage server as files. I want to know if we can access these files and where it will be stored(just like logs are stored in metadata table when it comes to oracle....)

ray.wurlod · Post by **ray.wurlod** » Mon Nov 13, 2006 10:30 pm

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.