TASKGROUPSTATISTICSRESET
The system table SYSINFO.TASKGROUPSTATISTICSRESET contains information about task groups and their resource consumption since the last RESET TASKGROUPSTATISTICS or RESET ALL.
|
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) |
|
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