Input for Utility Activity reports
Utility Activity reports use IFCIDs from the DB2 Accounting and Performance trace types.
The following table shows the utility events that can be collected, together with the trace classes and IFCIDs used.
| Db2 trace type | Db2 trace class | DB2 IFCID | Record type |
|---|---|---|---|
| Accounting | 1 | 3 | Accounting data |
| Bind Events | |||
| Performance | 3 | 22 | Minibinds generated by DB2 at bind prepare time |
| 63 | SQL statement to be parsed | ||
| 177 | Package allocation | ||
| Performance | 10 | 108 | Begin bind or rebind plan/package |
| 109 | End bind or rebind plan/package | ||
| 110 | Begin free plan/package | ||
| 111 | End free plan/package | ||
| Performance | 16 | 183 | Requesting agent data |
| Utilities | |||
| Performance | 10 | 23 | Start utility run, start of subtask. |
| 24 | Utility change; phase info, subtask info | ||
| 25 | Utility end | ||
| 219 | LISTDEF | ||
| 220 | Data set info | ||
| I/O Events | |||
| Performance | 4 | 6 | Begin Read I/O, data set on DASD to buffer pool |
| 7 | End Read I/O, data set on DASD to buffer pool | ||
| 8 | Begin synchronous Write I/O | ||
| 9 | Write end | ||
| 226 | Page latch wait begin | ||
| 227 | Page latch wait end | ||
| Lock Suspension Events | |||
| Performance | 6 | 44 | Lock suspension or an identity call to the IRLM |
| 45 | Lock resumption | ||
| 213 | Beginning of a wait for a drain lock | ||
| 214 | End of a wait for a drain lock | ||
| Performance | 17 | 213 | Beginning of a wait for a drain lock |
| 214 | End of a wait for a drain lock | ||
| 215 | Begin of a wait for the claim count to go to zero | ||
| 216 | End of a wait for the claim count to go to zero | ||
| Page and Row Locking Events | |||
| Performance | 6 | 20 | Page and row locking summary |
| 218 | Lock avoidance summary | ||
| Exit Events | |||
| Performance | 13 | 11 | Validation exit |
| 12 | Encode edit exit | ||
| 19 | Decode edit exit | ||