Troubleshooting Guide

Dump Files

Dump files are created when an error occurs for which there is additional information that would be useful in diagnosing a problem (such as internal control blocks). Every data item written to the dump files has a timestamp associated with it to help with problem determination. Dump files are in binary format and are intended for DB2 Customer Support representatives. They should be collected and sent along with the db2diag.log.

When a dump file is created or appended to, an entry is made in the db2diag.log indicating the time and the type of data written. These db2diag.log entries resemble the following:

1997-03-16-11.53.18.001160 Instance:payroll Node:000 PID:44829(db2agent (SAMPLE)) Appid:*LOCAL.payroll.970317140834 relation_data_serv sqlrerlg Probe:17 Database:SAMPLE DIA9999E An internal return code occurred. Report the following : "0xFFFFE101". Dump File: /home/db2/sqllib/db2dump/56772.000 Data : SECTION STMT (1)

Legend:

(1)

In this UNIX example, SECTION STMT data is stored in a file named 56772.000 located in the /home/db2/sqllib/db2dump directory.

Notes:

• For DB2 Enterprise - Extended Edition systems with a db2nodes.cfg file, the file extension identifies the node number. For example, the following entry indicates that the dump file was created by a DB2 process running on node 10:

  Dump File: /home/db2/sqllib/db2dump/56772.010 Data : SECTION STMT
  

• For UNIX-based systems, dump files might be created in core dump directories. These files are called DB2 core files and are specific to DB2. Collect these files in addition to the files specified in the db2diag.log.

  DB2 core files are located in the path $HOME/db2dump/core_directory, where core_directory is the core path directory name. There is one directory for each process. Directory names start with the letter "c", followed by the process identifier (pid) number of the affected process. A name extension provides the node number (for multinode systems with a db2nodes.cfg file).

  For example:

  • $HOME/db2dump/c56772.000 is a directory containing a core file for the process with pid 56772.
  • $HOME/db2dump/c56772/c56772.010 is a directory containing a core file for the process with pid 56772. It was created by a DB2 process running on node 10.