By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

LOG files not in a readable format

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.