Show TOC

Object documentationTASKLOADBALANCINGINFORMATION Locate this document in the navigation structure

 

The system table SYSINFO.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

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

More Information

Concepts of the Database System, Operating System Functions and Resources Used by Databases, Task Switching