The system table SYSINFO.BACKUPTHREADS contains information about I/O operations of the last backup or the current one.
THREADID |
FIXED(10) |
ID of the thread in the operating system |
THREADNAME |
CHAR(16) |
Name of the thread |
AUTOMATICLOGBACKUP |
CHAR(3) |
The automatic backup of the log has been enabled (YES | NO) |
IODIRECTION |
CHAR(6) |
I/O type (READ | WRITE) |
IOCOUNT |
FIXED(20) |
Number of I/O operations |
IOPAGECOUNT |
FIXED(20) |
Number of pages read/written during the I/O operation |
IOTIME |
FIXED(20) |
Total time of the I/O operations with active time measurement (µs) |
IOTIMEMEASUREMENTCOUNT |
FIXED(20) |
Number of measured I/O 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 data medium on which the I/O calls are executed |