Collecting Record Trace data with a Db2 trace

To create a record trace report, you must collect data by using a Db2 trace.

A record trace can be very long. Generally, run a Record trace on one component at a time to focus on a problem. The following example collects records associated with Accounting.

The easiest way to collect data for any OMEGAMON for Db2 Performance Expert report is to use the activate traces facility of the workstation monitor. You can use this facility to configure a Db2 trace and start and stop the trace from there. Using the activate traces facility also ensures that you include all data in the Db2 trace that is needed for a report.

Alternatively, you can start a Db2 trace as follows:

-START TRACE(A) DEST(OPX) CLASS(1, 2, 3, 5, 7, 8) BUFSIZE(512)
-START TRACE(P) DEST(OPX) CLASS(17,16,14,13,12,11,10,9,8,7,4,2,22,21,20,30) 
IFCID(20,22,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,53,55,58,59,60,61,
62,63,64,65,66,76,77,78,79,80,81,92,97,102,103,104,112,114,115,116,117,118,
119,120,124,129,140,141,142,143,144,145,146,147,149,150,151,152,153,154,
155,169,170,171,177,178,179,186,188,191,192,193,194,195,198,203,204,205,206,
207,208,209,210,218,219,220,224,228,229,233,235,236,237,238,239,243,247,254,
258,272,273,312,313,324,325,329,330,331,332,333,334) BUFSIZE(512)
-START TRACE(S) DEST(OPX) CLASS(6,5,3,1) BUFSIZE(512)