470,849 Members | 839 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

LOG files not in a readable format

Hi All:

I am new to db2 databases.
I use db2 V8.2 on AIX 5 platform.
My database has 6 primary Log files and no secondary log files.
When I try to read these files from the default locationi find that
these files are not in a
readable format i.e not in the text format.
Can someone suggest me how to get these files in a readable format.
Also suggest me some links for how to decide on the optimised db2
parameters settings
while creating a new database.
Regard

Oct 13 '06 #1
2 2062
The log files for DB2 include undo and redo information. This is meant
for the database engine to do its work. It's not meant for human
consumption. If you want to extract information from this, you will
need to purchase a third party tool.

If you are looking for diagnostic information, you look in the Journal
and the db2diag.log file.

Check out Chris Eaton's blog. He has some interesting talk about db2
parameters from some early entries.

Norm

Racerx wrote:
Hi All:

I am new to db2 databases.
I use db2 V8.2 on AIX 5 platform.
My database has 6 primary Log files and no secondary log files.
When I try to read these files from the default locationi find that
these files are not in a
readable format i.e not in the text format.
Can someone suggest me how to get these files in a readable format.
Also suggest me some links for how to decide on the optimised db2
parameters settings
while creating a new database.
Regard
Oct 16 '06 #2
Norm wrote:
The log files for DB2 include undo and redo information. This is meant
for the database engine to do its work. It's not meant for human
consumption. If you want to extract information from this, you will
need to purchase a third party tool.
Or you use DB2's log reader API. There is a description of (some of) the
log records if you search for the title "DB2 UDB log records" in the
manuals.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Oct 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by RickMuller | last post: by
2 posts views Thread by Sathyaish | last post: by
7 posts views Thread by Harrie | last post: by
4 posts views Thread by nielinjie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.