Collecting diagnostic data for installation and instance-creation problems

You might have to collect diagnostic data to solve problems that you encounter when installing Db2® software or creating an instance. If the Db2 installer generates the DBI2047E error message, informing you that installation or instance creation failed, you can use the db2support command to automatically collect diagnostic data.

Before you begin

To help ensure that you collect diagnostic data from the largest possible number of sources, you must have root authority. If you issue the db2support command with non-root authority, diagnostic data from some sources might not be collected.

To gather information about remote hosts with the -host parameter, you require an SSH connection.

About this task

The information that you gather by using the db2support -install command might be required by IBM Support to perform analysis. Diagnostic data is collected by issuing the db2support command both from log files on disk and from the output of other diagnostic commands.

The db2support command that is shipped with Db2 installation images supports only a subset of the command parameters that are available after you install the Db2 product. Until you have installed the Db2 product, the only db2support command parameters that you can use are the -install and -host parameters.

Procedure

To gather diagnostic data:

Use the information in the DBI2047E error message to determine the host or hosts where the failure occurred.
Issue the db2support command in one of the following ways:
- To collect diagnostic data on the local host, issue the following command:
```
db2support -install
```
- To collect diagnostic data on a remote host, issue the following command:
```
db2support -install -host hostname
```
  where hostname is the name of the remote host for which you want to collect diagnostic data. For example, to collect diagnostic data on the host hotellnx96, issue the following command:
```
db2support -install -host hotellnx96
```
- To collect diagnostic data on multiple hosts, issue the following command:
```
db2support -install -host hostname_list
```
  where hostname_list is a comma-separated list of hosts for which you want to collect diagnostic data. For example, to collect diagnostic data on the hosts hotellnx96, hotellnx97, and hotellnx98, issue the following command:
```
db2support -install -host hotellnx96,hotellnx97,hotellnx98
```

Results

The diagnostic data is collected in the db2support.zip file. The file is created in the current directory, if the current directory is writeable; otherwise, the file is placed in your home directory.

Example

The following example shows the typical output of the db2support -install command. In this case, diagnostic data is collected on the local host.



              _______   D B 2  S u p p o r t   ______


Output file is "/home/hotellnx96/db2docs1/db2support.zip"
Time and date of this collection: 2010-11-01-10.06.16.559562
Creating directory /home/hotellnx96/db2docs1/DB2SUPPORT
Starting collection on host hotellnx96
 Creating directory /home/hotellnx96/db2docs1/DB2SUPPORT/hotellnx96_IIH
Collecting resources group information
Collecting user identity information
Collecting current process information
Collecting active interprocess communications facilities information
Collecting system information
Collecting detailed data on system and hardware errors
Collecting registry contents
Collecting GPFS information
Collecting configuration, log and trace information for RSCT
Collecting information about installed Db2 products
Collecting information about state of db2 instance
Collecting "/home/hotellnx96/db2docs1/sqllib/db2dump/db2diag.log"
Collecting /etc/services
Collecting /home/hotellnx96/db2docs1/sqllib/db2nodes.cfg
Collecting directory /home/hotellnx96/db2docs1/sqllib/db2dump
Collection on host hotellnx96 completed
Compressing files in /home/hotellnx96/db2docs1/DB2SUPPORT directory
Collecting /home/hotellnx96/db2docs1/db2support.log
Collecting db2support.out


db2support is now complete.
 An archive file has been produced: "/home/hotellnx96/db2docs1/db2support.zip"

What to do next

If you are working with IBM Support to troubleshoot a Db2 installation or instance-creation problem, you might be given instructions on how to upload the db2support.zip file for analysis by support personnel.