The system table IOTHREADSTATISTICS contains information about all I/O operations per volume since the last start of the database instance.
IOTHREADSTATISTICS
VOLUMEID |
FIXED(10) |
Volume ID in the runtime environment |
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 |
PATH |
CHAR (256) |
Name of the disk space area on which the I/O calls are executed |
See also: