The system table SYSINFO.SERVERTASKS describes the tasks that are used internally for the parallel processing of SQL statements.
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 |
Concepts of the Database System, Tasks