DB2 Version 9.7 for Linux, UNIX, and Windows
After you install a DB2 Server product > Verifying your installation >

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 the DB2 product you have 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 you have installed will be displayed.

The following table shows the location of DB2 objects after a default installation.

Table 29. DB2 objects and their locations
DB2 Object Location
DAS information
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1
  • For Windows Vista and later 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 XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
  • For Windows Vista and later 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 XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
  • For Windows Vista and later 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\SQLOGDIR
Installation log file
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\Administrator\My Documents\DB2LOG
  • For Windows Vista and later operating systems: C:\Users\USER_NAME\Documents\DB2LOG
Instance
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
  • For Windows Vista and later operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Instance information
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
  • For Windows Vista and later operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
Node directory
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2\SQLNODIR
  • For Windows Vista and later 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 XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
  • For Windows Vista and later operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2
System database directory
  • For Windows XP and Windows 2003 operating systems: C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2\SQLDBDIR
  • For Windows Vista and later operating systems: C:\ProgramData\IBM\DB2\DB2COPY1\DB2\SQLDBDIR

The following figures illustrate an example of the DB2 directory structure after installation on Windows XP or Windows 2003 operating systems using the default options. In these figures, there are two instances, DB2 and MYINST. The directories DB2 and MYINST under the local disk C: will only appear if a database has been created under the appropriate instance.

Directory structure - instance information

Directory information

  1. Contains the databases 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 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

[ Top of Page | Previous Page | Next Page | Contents ]