DB2 Version 9.7 for Linux, UNIX, and Windows

Splitting a diagnostic data directory path by database partition server, database partition, or both

The default DB2® diagnostic data directory path setting of the diagpath database manager configuration parameter collects all diagnostic information within a single diagnostic data directory. You can split the diagnostic data directory path so that separate directories are created and named according to the database partition server, database partition, or both. In this way, diagnostic dump files, previously stored in a single directory, are now stored in separate directories according to the database partition server or database partition from which the diagnostic data dump originated.

About this task

You will be able to split a diagnostic data directory path to separately store diagnostic information according to the database partition server or database partition from which the diagnostic data dump originated.

Restrictions

Splitting a diagnostic data directory path, to keep multiple sources of diagnostic information separated, is mostly useful in partitioned database environments.

Before you begin

DB2 Version 9.7 Fix Pack 1 or a later fix pack is required.

Procedure

Splitting diagnostic data directory path per physical database partition server
- To split the default diagnostic data directory path, execute the following step:
  - Set the diagpath database manager configuration parameter to split the default diagnostic data directory path per physical database partition server by issuing the following command:
```
db2 update dbm cfg using diagpath '"$h"'
```
  This command creates a subdirectory under the default diagnostic data directory with the computer name, as in the following:
```
Default_diagpath/HOST_db-partition-server-name
```
- To split a user specified diagnostic data directory path (for example, /home/usr1/db2dump/), execute the following step:
  - Set the diagpath database manager configuration parameter to split the /home/usr1/db2dump/ diagnostic data directory path per database partition server by issuing the following command:
```
db2 update dbm cfg using diagpath '"/home/usr1/db2dump/ $h"'
```
    Note: A blank space must separate /home/usr1/db2dump/ and $h.
  This command creates a subdirectory under the /home/usr1/db2dump/ diagnostic data directory with the database partition server name, as in the following:
```
/home/usr1/db2dump/HOST_db-partition-server-name
```
Splitting diagnostic data directory path per database partition
- To split the default diagnostic data directory path, execute the following step:
  - Set the diagpath database manager configuration parameter to split the default diagnostic data directory path per database partition by issuing the following command:
```
db2 update dbm cfg using diagpath '"$n"'
```
  This command creates a subdirectory for each partition under the default diagnostic data directory with the partition number, as in the following:
```
Default_diagpath/NODEnumber
```
- To split a user specified diagnostic data directory path (for example, /home/usr1/db2dump/), execute the following step:
  - Set the diagpath database manager configuration parameter to split the /home/usr1/db2dump/ diagnostic data directory path per database partition by issuing the following command:
```
db2 update dbm cfg using diagpath '"/home/usr1/db2dump/ $n"'
```
    Note: A blank space must separate /home/usr1/db2dump/ and $n.
  This command creates a subdirectory for each partition under the /home/usr1/db2dump/ diagnostic data directory with the partition number, as in the following:
```
/home/usr1/db2dump/NODEnumber
```
Splitting diagnostic data directory path per physical database partition server and per database partition
- To split the default diagnostic data directory path, execute the following step:
  - Set the diagpath database manager configuration parameter to split the default diagnostic data directory path per physical database partition server and per database partition by issuing the following command:
```
db2 update dbm cfg using diagpath '"$h$n"'
```
  This command creates a subdirectory for each logical partition on the database partition server under the default diagnostic data directory with the database partition server name and partition number, as in the following:
```
Default_diagpath/HOST_db-partition-server-name/NODEnumber
```
- To split a user specified diagnostic data directory path (for example, /home/usr1/db2dump/), execute the following step:
  - Set the diagpath database manager configuration parameter to split the /home/usr1/db2dump/ diagnostic data directory path per database partition server and per database partition by issuing the following command:
```
db2 update dbm cfg using diagpath '"/home/usr1/db2dump/ $h$n"'
```
    Note: A blank space must separate /home/usr1/db2dump/ and $h$n.
  This command creates a subdirectory for each logical partition on the database partition server under the /home/usr1/db2dump/ diagnostic data directory with the database partition server name and partition number, as in the following:
```
/home/usr1/db2dump/HOST_db-partition-server-name/NODEnumber
```
  For example, an AIX® database partition server, named boson, has 3 database partitions with node numbers 0, 1, and 2. An example of a list output for the directory is similar to the following:
```
usr1@boson /home/user1/db2dump->ls -R *
HOST_boson:

HOST_boson:
NODE0000 NODE0001 NODE0002

HOST_boson/NODE0000:
db2diag.log db2eventlog.000 db2resync.log db2sampl_Import.msg events usr1.nfy

HOST_boson/NODE0000/events:
db2optstats.0.log

HOST_boson/NODE0001:
db2diag.log db2eventlog.001 db2resync.log usr1.nfy stmmlog

HOST_boson/NODE0001/stmmlog:
stmm.0.log

HOST_boson/NODE0002:
db2diag.log db2eventlog.002 db2resync.log usr1.nfy
```

What to do next

Note:

To check that the setting of the diagnostic data directory path was successfully split, execute the following command:
```
db2 get dbm cfg | grep DIAGPATH
```
A successfully split diagnostic data directory path returns the values $h, $n, or $h$n with a preceding blank space. For example, the output returned is similar to the following:
```
Diagnostic data directory path            (DIAGPATH) = /home/usr1/db2dump/ $h$n 
```

To merge separate db2diag log files to make analysis and troubleshooting easier, use the db2diag -merge command. For additional information, see: "db2diag - db2diag logs analysis tool command" and "Analyzing db2diag log files using db2diag tool".