Learning Visually with Examples [Electronic resources]

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

نسخه متنی -صفحه : 312/ 223
نمايش فراداده

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:

db2trc on

options

Use

db2trc h to display all the available options. DB2 Technical Support usually requires you to perform the following steps to collect a trace.

1.

Turn on the DB2 trace to collect the last 8MB of information in the trace:

db2trc on l 8M

2.

Recreate the error.

3.

Dump the trace information into a binary file:

db2trc dmp db2trc.dmp

4.

Turn off the DB2 trace:

db2trc off

5.

Format the trace dump file into a text file that sorts the records by process/thread:

db2trc fmt db2trc.dmp

filename

.fmt

6.

Format the trace dump file into a text file that sorts the records chronologically:

db2trc flw db2trc.dmp

filename

.flw