The SYSINFO.TASKLOADBALANCINGTASKMOVES system table describes the history of the task group move.
MOVETIME |
TIMESTAMP |
Time of the task group move |
TASKID |
FIXED(10) |
ID of the task that moved between two task groups |
MAXTASKRUNNABLETIME |
FIXED(20) |
Maximum time within the measurement interval (µs) for which the task was runnable |
SOURCETASKGROUP |
FIXED(10) |
ID of the source task group |
SOURCEMAXTASKRUNNABLETIME |
FIXED(20) |
Maximum time within the measurement interval (µs) for which a task in the source task group was runnable |
DESTINATIONTASKGROUP |
FIXED(10) |
ID of the destination task group |
DESTINATIONMAXTASKRUNNABLETIME |
FIXED(20) |
Maximum time within the measurement interval (µs) for which a task in the destination task group was runnable |
Concepts of the Database System, Task Switching