IBM Support

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

Technote (FAQ)


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.

Related information

Directory Structure DB2 Windows
diagpath - Diagnostic data path config parameter

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 Connect Windows 9.5 All Editions

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7, 9.8, 10.1, 10.5

Operating system(s): Windows

Software edition: Advanced Enterprise Server, Advanced Workgroup Server, Enterprise Server, Express, Express-C, Personal, Workgroup Server

Reference #: 1380494

Modified date: 2016-05-24