IOTHREADSTATISTICS
The system table SYSINFO.IOTHREADSTATISTICS contains information about all I/O operations per volume queue since the last start of the database.
|
VOLUMETYPE |
CHAR(1) |
Volume type (L: log, D: data, T: trace, M: mirrored log) |
|
VOLUMEID |
FIXED(10) |
Volume identification of the runtime environment |
|
PARTITIONID |
FIXED(5) |
Identification of partition |
|
QUEUEID |
FIXED(10) |
Queue index on a volume (0-based) |
|
TASKGROUPID |
FIXED(10) |
Task group identification if I/O is executed w/o using a queue |
|
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,2) |
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 |