Section 17.7. The DB2 Trace Facility


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 



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net