Obtaining a DB2 trace using db2trc
The db2trc command controls the trace
facility provided with DB2.
The trace facility records information about operations and formats
this information into a readable form.
Dumping a DB2 trace file
After the trace facility has been enabled using the ON option,
all subsequent work done by the instance will be traced.
Formatting a DB2 trace
The dump file created by the db2trc dmp command
is in binary format and is not readable. You can format the binary
dump file into a readable file to show the flow control and send the
formatted output to a null device.