IBM Tivoli Storage Manager, Version 7.1

Locating DB2 diagnostic log files

The db2diag.log file contains diagnostic information that can help you to resolve problems that might occur with your database.

The location of the db2diag.log file and the DB2® first occurrence data capture (FODC) files depends on your DB2 configuration settings or the DB2 environmental variable settings. DB2 writes messages about internal operations, events, or status in the administration notification log file (db2SID.nfy).

Complete the following steps to determine where the diagnostic data directory path is located:

Log in as the server user instance.
Issue the following command:
```
db2 get dbm cfg | grep DIAGPATH
```
If no path is specified in the DIAGPATH configuration parameter, the diagnostic data directory is in the sqllib/db2dump subdirectory of your instance directory. For example, /home/tsminst1/sqllib/db2dump where /home/tsminst1 is the instance home directory.

Complete the following steps to determine where the diagnostic data directory path is located:

Stop the DB2 interactive mode. Start a DB2 command-line prompt and issue the quit command.
Find the path by using the DIAGPATH configuration parameter. Issue command
```
db2 get dbm cfg | findstr /s /i diagpath
```
If no path is specified in the DIAGPATH configuration parameter, the DB2INSTPROF directory path is used. Find the path that was set in the DB2INSTPROF environment variable. Issue the following command from the DB2 command-line prompt:
```
db2set db2instprof
```
The output from this command shows the location of DB2 data files. The diagnostic log file is in the instance sub directory of the directory that is specified by the DB2INSTPROF registry variable. For example, for the server instance TSMSERVER1, the db2set deb2instprof command shows this path:
```
C:\ProgramData\IBM\DB2\DB2TSM1 
```
The diagnostic log file is in the TSMSERVER1 sub directory:
```
C:\ProgramData\IBM\DB2\DB2TSM1\TSMSERVER1
```
If the DB2INSTPROF environment variable is not set, then x:\SQLLIB\DB2INSTANCE is used. x:\SQLLIB is the drive reference and it is also the directory that is specified in the DB2PATH registry variable. The value of DB2INSTANCE is the name of the instance. You do not need to call the directory SQLLIB. The first part of the output from the db2set db2path command is the diagnostic data directory path with the instance name added. The output shows the following directory path:
```
C:\Program Files\Tivoli\TSM\db2\TSMINST1
```
where DB2PATH is C:\Program Files\Tivoli\TSM\db2 and the instance name is TSMINST1.

Feedback