Specific to Adaptive Server in threaded mode, contains one row for each task.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monTask are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
tinyint |
NOT NULL |
ID of the instance within the cluster |
KTID |
int |
ID of the kernel task |
|
ThreadPoolID |
int |
NULL |
ID of the thread pool this task is associated with |
ThreadID |
int |
ID of the thread running this task |
|
KPID |
int |
NULL |
Adaptive Server kernel process ID (KPID) |
SPID |
int |
Session process identifier (spid) |
|
Name |
varchar(30) |
Name of the task |
|
ThreadPoolName |
varchar(30) |
NULL |
Name of the thread pool this task is associated with |
