Finding the current db2diag.log file for Tivoli Storage Manager troubleshooting

Question
The IBM support team requests the db2diag.log file for analysis of DB2 related issues during the Tivoli Storage Manager failure analysis. Many administrators would not be aware of the location of the file in DB2 directory for Tivoli Storage Manager, This document explains on how to find the location of the file by execution of some commands.

Cause
db2diag.log for Tivoli Storage Manager location unknown

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

1. Stop the DB2 interactive mode. Start a DB2 command-line prompt and issue the quit command.

2. 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.

3. 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

4. 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 -all shows 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.