Object documentationSERVERTASKS Locate this document in the navigation structure

 

The system table SYSINFO.SERVERTASKS describes the tasks that are used internally for the parallel processing of SQL statements.

Structure

SERVERTASKS

TASKID

FIXED(10)

ID of the server task

ISASSIGNED

CHAR(3)

Server task has been assigned (YES | NO)

ISRESERVED

CHAR(3)

Server task has been reserved for a task (YES | NO)

LASTJOBDESCRIPTION

CHAR(32)

Description of the job for which a reserved server task is used

More Information

Concepts of the Database System, Tasks