Performance trace

The performance trace is intended for performance analysis and tuning. This trace includes records of specific events in the system, including events related to distributed data processing. The data can be used for program, resource, user, and subsystem-related tuning.

Begin general-use programming interface information. You can use this information to further identify a suspected problem, or to tune Db2 programs and resources for individual users or for Db2 as a whole.

You cannot automatically start collecting performance data when you install or migrate Db2. The performance trace is started when you issue the following command:

-START TRACE(PERFM)

The performance trace defaults to GTF.

Table 1. Classes for Db2 performance trace
Class Description of class Activated IFCIDs
1 Background events. This default class is also activated when you omit the CLASS keyword from the START TRACE command when you start the performance trace. 0001, 0002, 0031, 0042, 0043, 0076-0079, 0102, 0103, 0105-0107, 0153
2 Subsystem events. This default class is also activated when you omit the CLASS keyword from the START TRACE command when you start the performance trace. 0003, 0068-0075, 0080-0089, 0106, 0174, 0175
3 SQL events. This default class is also activated when you omit the CLASS keyword from the START TRACE command when you start the performance trace. 0022, 0053, 0055, 0058-0066, 0092, 0095-0097, 0106, 0112, 0173, 0177, 0233, 0237, 0250, 0272, 0273, 0325
4 Reads to and writes from the buffer and EDM pools. 0006-0010, 0029-0030, 0105-0107, 0127, 0128, 0226, 0227, 0321, 0322
5 Write to log; archive log. 0032-0041, 0104, 0106, 0114-0120, 0228, 0229
6 Summary lock information. 0020, 0044, 0045, 0105-0107, 0172, 0196, 0213, 0214, 0218, 0337
7 Detailed lock information. 0021, 0105-0107, 0223
8 Data scanning detail. 0013-0018, 0105-0107, 0125, 0221, 0222, 0231, 0305, 0311, 0363
9 Sort detail. 0026-0028, 0095-0096, 0106
10 BIND, commands, and utilities detail. 0023-0025, 0090, 0091, 0105-0107, 0108-0111, 0201, 0256
11 Execution unit switch and latch contentions. 0046-0052, 0056, 0057, 0093, 0094, 0106, 0113
12 Storage manager. 0098-0101, 0106
13 Edit and validation exits. 0011, 0012, 0019, 0105-0107
14 Entry from and exit to an application. 0067, 0106, 0121, 0122
15 Installation-defined performance record. 0154
16 Distributed processing. 0157-0163, 0167, 0183
17 Claim and drain information. 211-216
18 Event-based console messages. 0197
19 Data set open and close activity. 0370, 0371
20 Data sharing coherency summary. 0249-0251, 0256-0257, 0261, 0262, 0267, 0268
21 Data sharing coherency detail. 0255, 0259, 0263
22 Authorization exit parameters. 0314
23 Language environment runtime diagnostics. 0327
24 Stored procedure detail. 0380, 0499
25-29 Reserved.  
30 - 32 Available for local use.  

End general-use programming interface information.