Object documentationTASKGROUPSTATISTICSRESET Locate this document in the navigation structure

 

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

Structure

TASKGROUPSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

TASKGROUPID

FIXED(10)

Identification of the task group

MAXUSEDRUNQUEUELENGTH

FIXED(10)

Maximum number of tasks lined up for CPU assignment

DISPATCHCOUNT

FIXED(20)

Number of task scheduler calls

TASKSWITCHCOUNT

FIXED(20)

Number of task switches in this task group

COMMANDCOUNT

FIXED(20)

Number of commands executed by the tasks of this task group

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)

More Information

TASKGROUPSTATISTICS

Concepts of the Database System, Tasks