IBM Support

Where is the db2diag.log located on DB2 for Windows?

Question & Answer


Question

Where is the db2diag.log located on Windows? Where is the default location for the db2diag.log when the Database Manager configuration (dbm cfg) shows DIAGPATH as blank?

Answer

The location of the default location of the db2diag.log is as follows:


For Windows Vista and later operating systems:
C:\ProgramData\IBM\DB2\<db2 copy name>\DB2

For older Windows operating systems :
C:\Documents and Settings\All Users\Application Data\IBM\DB2\<DB2 copy name>\DB2


(NOTE: "ProgramData" and "Application Data" folders are usually hidden on Windows.)

The default location can be modified by updating the 'DIAGPATH' Database Manager configuration (dbm cfg) parameter to a desired location using the following command:

db2 update dbm cfg using diagpath "<path to db2diag.log>"

(NOTE: The path to db2diag.log may need to be in quotes if there is a space in the path name.)


If you have IBM Data Server Driver package installed, the db2diag.log files will be located in db2 subdirectory of the driver install directory.

For example, if you installed the driver under:
C:\Program Files\IBM\IBM DATA SERVER DRIVER

the db2diag.log will be under
C:\Program Files\IBM\IBM DATA SERVER DRIVER\db2.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - db2diag.log","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21380494