Object documentationTASKLOADBALANCINGTASKGROUPSTATES Locate this document in the navigation structure

 

The system table SYSINFO.TASKLOADBALANCINGTASKGROUPSTATES contains information about the task load balancing values of the individual task groups in the current measurement interval.

Structure

TASKLOADBALANCINGTASKGROUPSTATES

TASKGROUPID

FIXED(10)

ID of the task group

MOVETASKTOTASKGROUPID

FIXED(10)

ID of the target task group to which a task of the task group (TASKGROUPID) is to be moved

MOVEABLETASKCOUNT

FIXED(10)

Number of tasks in the task group that allow a task group move

INTERVALSTARTTIME

TIMESTAMP

Start time of the current measurement interval

TASKGROUPSLEEPTIME

FIXED(20)

Time (µs) within the measurement interval in which the task group was in sleep state (sleep on semaphore)

TOTALTASKRUNNABLETIME

FIXED(20)

Total time (µs) within the measurement interval for which the tasks of the task group were runnable

MAXTASKRUNNABLETIME

FIXED(20)

Maximum time (µs) within the measurement interval for which the tasks of the task group were runnable

More Information

Concepts of the Database System, Load Balancing between User Kernel Threads