Show TOC

SERVERTASKSLocate this document in the navigation structure

Definition

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

Structure

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