IOTHREADSTATISTICS

Definition

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

Structure

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:

IOTHREADSTATISTICSRESET