The system table SYSINFO.IOTHREADSTATISTICS contains information about all I/O operations per volume queue since the last start of the database.
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 |
QUEUEPRIORITY |
CHAR(6) |
Queue priority (LOW | MEDIUM | HIGH) which can include I/O requests of the same or lower priority |
LOADAVG |
FIXED(16) |
Average number of I/O requests in this queue per second |
PATH |
CHAR(256) |
Name of the disk space area on which the I/O calls are executed |