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:
Concepts of the Database System, Overview of Tasks, Task Switching