Object documentationIOTHREADSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.IOTHREADSTATISTICS contains information about all I/O operations per volume queue since the last start of the database.

Structure

IOTHREADSTATISTICS

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

More Information

IOTHREADSTATISTICSRESET