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.
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.
| 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. |