The system table SYSINFO.IOTHREADSTATISTICSRESET contains information about all I/O operations per volume queue since the last RESET IOTHREADSTATISTICS or RESET ALL.
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
VOLUMEID |
FIXED(10) |
Volume identification of the runtime environment |
QUEUEID |
FIXED(10) |
Queue index on a volume (0-based) |
VOLUMETYPE |
CHAR(1) |
Volume type (L: log, D: data, T: trace, M: mirrored log) |
READCOUNT |
FIXED(20) |
Number of reads |
READPAGECOUNT |
FIXED(20) |
Number of pages read during the read process |
READTIME |
FIXED(20) |
Total time of the read operation with active time measurement (µs) |
READTIMEMEASUREMENTCOUNT |
FIXED(20) |
Number of measured reads |
WRITECOUNT |
FIXED(20) |
Number of write operations |
WRITEPAGECOUNT |
FIXED(20) |
Number of pages written during the read process |
WRITETIME |
FIXED(20) |
Total time of the write operation with active time measurement (µs) |
WRITETIMEMEASUREMENTCOUNT |
FIXED(20) |
Number of measured write operations |
PENDINGIOCOUNT |
FIXED(5) |
Number of pending I/O calls |
MAXPENDINGIOCOUNT |
FIXED(5) |
Maximum number of pending I/O calls |