TASKGROUPSTATISTICSRESET

Definition

The system table TASKGROUPSTATISTICSRESET contains information about task groups and their resource usage since the last RESET TASKGROUPSTATISTICS or RESET ALL.

Structure

TASKGROUPSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

TASKGROUPID

FIXED(10)

ID of the task group

MAXUSEDRUNQUEUELENGTH

FIXED(10)

Maximum number of tasks lined up for CPU assignment

IDLECOUNT

FIXED(20)

Number of time intervals in which the CPU was released

IDLETIME

FIXED(20)

Total time for which the CPU was released (µs)

IOWAITCOUNT

FIXED(20)

Number of time intervals in which waits for outstanding I/O operations occurred

IOWAITTIME

FIXED(20)

Total wait time for outstanding I/O operations (µs)

USEDSYSTEMTIME

FIXED(20)

Total CPU time used in system mode (µs)

USEDUSERTIME

FIXED(20)

Total CPU time used in user mode (µs)

See also:

TASKGROUPSTATISTICS

Concepts of the Database System, Overview of Tasks, Task Switching