TASKGROUPSTATISTICS
The system table SYSINFO.TASKGROUPSTATISTICS contains information about task groups and their resource usage since the last start of the database.
|
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 |
|
U S E D RUNQUEUELENGTH |
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) |
|
RUNNINGTASKID |
FIXED(10) |
Identification of the task that is currently running |
|
CONTEXTSWITCHCOUNT |
FIXED(20) |
Number of task switches inside of this task group with active time measurement |
|
CONTEXTSWITCHTIME |
FIXED(20) |
Total time of the task switches with active time measurement (microseconds) |
|
SCHEDULERCALLCOUNT |
FIXED(20) |
Number of scheduler calls inside of this task group with active time measurement |
|
SCHEDULERCALLTIME |
FIXED(20) |
Total time spent in scheduler calls with active time measurement (microseconds) |
Concepts of the Database System, Tasks