Object documentationTASKGROUPSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.TASKGROUPSTATISTICS contains information about task groups and their resource usage since the last start of the database.

Structure

TASKGROUPSTATISTICS

TASKGROUPID

FIXED(10)

Identification of the task group

THREADID

FIXED(10)

Identification of the thread in the operating system

TASKCLUSTER

CHAR(20)

Task cluster to which this task group belongs

TASKCOUNT

FIXED(10)

Number of tasks in this group

THREADSTATE

CHAR(20)

Operation state of this task group

USEDRUNQUEUELENGTH

FIXED(10)

Number of tasks lined up for CPU assignment

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

TASKGROUPSTATISTICSRESET

Concepts of the Database System, Tasks