17.7. The DB2 Trace Facility
Sometimes the information in the FFDC files is not enough to determine the cause of a problem. Under normal circumstances, you should only take a trace if asked by DB2 Technical Support. The process of taking a trace entails setting up the trace facility, reproducing the error, and collecting the data.The command to turn on the DB2 trace is:
Use db2trc h to display all the available options. DB2 Technical Support usually requires you to perform the following steps to collect a trace.
db2trc on options
1. | Turn on the DB2 trace to collect the last 8MB of information in the trace:
|
2. | Recreate the error. |
3. | Dump the trace information into a binary file:
|
4. | Turn off the DB2 trace:
|
5. | Format the trace dump file into a text file that sorts the records by process/thread:
|
6. | Format the trace dump file into a text file that sorts the records chronologically:
|