The system table TASKLOADBALANCINGINFORMATION describes the current task load balancing parameters and provides information about the current measurement interval for task load balancing.
TASKLOADBALANCINGINFORMATION
MEASUREMENTINTERVALTIME |
FIXED(10) |
Measurement interval (s) between task load balancing operations and evaluations |
INTERVALSTARTTIME |
TIMESTAMP |
Start time of the current measurement interval |
MEASUREMENTINTERVALS |
FIXED(10) |
Number of measurement intervals since the database kernel was started |
VALUEQUALITY |
FIXED(3) |
Value (%) that indicates the maximum tolerance range allowed when time values are compared. If the time difference of two runnable tasks is within this tolerance range, the time values are regarded as identical. |
MINDIFFERENCE |
FIXED(3) |
Percentage by which a task to be moved must be runnable for longer in its task group than the longest runnable task of the destination task group |
See also:
Concepts of the Database System, Overview of Tasks, Task Switching