Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DB2 Log Files where? 2
- Thread starter gowie
- Start date
-
2
- #2
DB2 uses logfiles to be able to rollback/restore. I think these are binary files, you cannot do anything with.
path like : K:\DB2\NODE0000\SQL00001\SQLOGDIR
Then there is the db2diag.log that will keep up with all sorts of activity in the database:
path like:L:\Program Files\SQLLIB\DB2
This file stores error messages and such things like write activity on tables...
T. Blom
Information analyst
tbl@shimano-eu.com
path like : K:\DB2\NODE0000\SQL00001\SQLOGDIR
Then there is the db2diag.log that will keep up with all sorts of activity in the database:
path like:L:\Program Files\SQLLIB\DB2
This file stores error messages and such things like write activity on tables...
T. Blom
Information analyst
tbl@shimano-eu.com
If you issue the command:
db2 get database configuration for xxxxx
(x's = database name)
Look at the line:
"Path to log files"
This will show you where the log files are stored. Beyond that, I don't know who you'd be able to read their contents.
![[3eyes]](/data/assets/smilies/3eyes.gif "[3eyes] [3eyes]")
db2 get database configuration for xxxxx
(x's = database name)
Look at the line:
"Path to log files"
This will show you where the log files are stored. Beyond that, I don't know who you'd be able to read their contents.
- Status
Similar threads
- Locked
- Question