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.