DB2 diagnostic path error in idsdbmaint tool

On Microsoft Windows operating systems, if DB2 is installed with the installation wizard then the idsdbmaint tool is unable to fetch DB2 diagnostic path. This problem does not occur if DB2 is installed separately (without using the installation wizard). If the idsdbmaint tool is not able to fetch DB2 diagnostic path then the index reorganization operation does not have the required impact. This problem is because the idsdbmaint tool requires DB2 diagnostic path for the index reorganization and row compression features to function. The idsdbmaint tool might display the following error message when this problem is encountered.

GLPDBA048E The diagpath for database instance 'dsrdbm01' could not be determined.

The following error is observed when the idsdbmaint command is run:

c:\>idsdbmaint -I dsrdbm01 -r
GLPWRP123I The program 'C:\Program Files\IBM\LDAP\V.2\sbin\32\dbmaint.exe' 
 is used with the following arguments '-I dsrdbm01 -r'.
GLPSRV200I Initializing primary database and its connections.
GLPDBA037I Row compression task will be performed.
GLPDBA048E The diagpath for database instance 'dsrdbm01' could not be determined.

Workaround

To resolve the issue of DB2 diagnostic path when you install DB2 using the installation wizard on Windows operating system, issue the following commands:

db2start
db2 connect to instance name
db2 update dbm cfg using DIAGPATH C:\instancename
db2 terminate
db2stop