where are log file stored in DB2? i am searching for a file with name Updatedb20100604182008.log
+1
A:
from this page:
http://www.ibm.com/developerworks/data/library/techarticle/0301kline/0301kline.html
(The article goes into further detail about default locations as well.)
The database logs are initially created in a directory called SQLOGDIR, a sub-directory of the database directory. You can change the location where active logs and future archive logs are placed by changing the value for this configuration parameter to point to either a different directory, or to a device. Archive logs that are currently stored in the database log path directory are not moved to the new location if the database is configured for roll-forward recovery.
Because you can change the log path location, the logs needed for roll-forward recovery may exist in different directories or on different devices. You can change this configuration parameter during the roll-forward process to allow you to access logs in multiple locations.
The change to the value of newlogpath will not be applied until the database is in a consistent state. An informational database configuration parameter, database_consistent, indicates the status of the database.
Note: The database manager writes to transaction logs one at a time. The total size of transactions that can be active is limited by the database configuration parameters:
David Stratton
2010-06-04 13:05:53