Input for I/O Activity reports
I/O Activity reports use IFCIDs from the Db2 Performance trace type, basically trace classes 4, 5, and 21.
The following table shows the IFCIDs used in I/O Activity reports.
I/O Activity reports | IFCIDs used | Db2 trace type and trace class |
---|---|---|
Buffer Pool | 6, 7, 8, 9, 10, 105, 107 | Performance, class 4 |
EDM Pool | 29, 30, 105, 107 | Performance, class 4 |
Active Log | 34, 35, 36, 37, 38, 39 | Performance, class 5 |
Archive Log/BSDS | 34, 35, 36, 37, 40, 41, 114, 115, 116, 119, 120 | Performance, class 5 |
Cross-Invalidation | 105, 107, 255 | Performance, class 21 |
Note: If you want to include Sequential Prefetch Read I/O operations in the report, do not qualify
the Db2 START TRACE command with a plan name or an authorization ID. Such a
qualification for performance trace class 4 reduces the data Db2 puts in the user's task TCB and
omits all asynchronous tasks including Sequential Prefetch.