TASKLOADBALANCINGINFORMATION

Definition

The system table TASKLOADBALANCINGINFORMATION describes the current task load balancing parameters and provides information about the current measurement interval for task load balancing.

Structure

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