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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset