Directory structure for your installed Db2 database product (Windows)

When you install Db2 database products, you can specify a Db2 database product installation path or else use the default path. After installation, Db2 objects are created in these directories.

Follow these steps to verify that the Db2 product was installed on Windows.
  1. From a command prompt, type the regedit command. The Registry Editor window opens.
  2. Expand HKEY_LOCAL_MACHINE > Software > IBM > DB2
The Db2 product that was installed is displayed.
The following table shows the location of Db2 objects after a default installation.
Table 1. Db2 objects and their locations
Db2 Object Location
DAS information
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1
Database configuration file SQLDBCON C:\DB2\NODE0000\SQL00001
Database directory
Contains files needed for:
  • buffer pool information
  • history information
  • log control files
  • storage path information
  • table space information
C:\DB2\NODE0000\SQL00001
Database manager configuration file db2systm
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Db2 commands C:\Program Files\IBM\SQLLIB\BIN
Db2 error messages file db2diag log files
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Db2 installation path C:\Program Files\IBM\SQLLIB
Directory for event monitor data C:\DB2\NODE0000\SQL00001\DB2EVENT
Directory for transaction log files C:\DB2\NODE0000\SQL00001\LOGSTREAM0000
Installation log file
  • For Windows operating systems: C:\Users\USER_NAME\Documents\DB2LOG
Instance
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Instance information
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Node directory
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2\SQLNODIR
Local database directory for the instance called Db2 C:\DB2\NODE0000\SQLDBDIR
Partitioned database environment file db2nodes.cfg
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
System database directory
  • For Windows operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2\SQLDBDIR

The following figures illustrate an example of the Db2 directory structure after installation on Windows operating systems that use the default options. These figures have two instances, Db2 and MYINST. The directories DB2 and MYINST under the local disk C: appears only if a database was created under the appropriate instance.

Directory structure - instance information

Directory information
  1. Contains the databases that are created under the C: drive for the instance named Db2.
  2. Contains the information for the DAS.
  3. Contains the instance information for the instance named Db2.
  4. Contains the instance information for the instance named MYINST.
  5. Contains the databases that are created under the C: drive for the instance named MYINST.

Directory structure - directory information

Instance information
Instance information
  1. System database directory
  2. Node directory
  3. The db2diag log files Db2 error messages.
  4. The db2nodes.cfg file is used in a partitioned database environment.
  5. Database manager configuration file

Directory structure - local directory information

Local directory information
  1. Local database directory for the instance Db2
  2. Local database directory for the instance MYINST
  3. Database configuration file

Directory structure - installation log file location

Location of your Db2 log file