The system table SYSINFO.TASKLOADBALANCINGINFORMATION describes the current task load balancing parameters and provides information about the current measurement interval for task load balancing.
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 |
VALUEEQUALITY |
FIXED(3) |
Percentage 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 |
Concepts of the Database System, Operating System Functions and Resources Used by Databases, Task Switching