Each row represents a service class.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
SERVICECLASSNAME | VARCHAR (128) | Name of the service class. | |
PARENTSERVICECLASSNAME | VARCHAR (128) | Y | Service class name of the parent service superclass. |
SERVICECLASSID | SMALLINT | Identifier for the service class. | |
PARENTID | SMALLINT | Identifier for the parent service class for this service class. 0 if this service class is a super service class. | |
CREATE_TIME | TIMESTAMP | Time when the service class was created. | |
ALTER_TIME | TIMESTAMP | Time when the service class was last altered. | |
ENABLED | CHAR (1) | State of the service class.
|
|
AGENTPRIORITY | SMALLINT | Thread priority of the agents in the service class relative
to the normal priority of DB2® threads.
|
|
PREFETCHPRIORITY | CHAR (1) | Prefetch priority of the agents in the service class.
|
|
BUFFERPOOLPRIORITY | CHAR (1) | Bufferpool priority of the agents in the service class
|
|
INBOUNDCORRELATOR | VARCHAR (128) | Y | For future use. |
OUTBOUNDCORRELATOR | VARCHAR (128) | Y | String used to associate the service class with an operating system workload manager service class. |
COLLECTAGGACTDATA | CHAR (1) | Specifies what aggregate activity data should be captured
for the service class by the applicable event monitor.
|
|
COLLECTAGGREQDATA | CHAR (1) | Specifies what aggregate activity data should be captured
for the service class by the applicable event monitor.
|
|
COLLECTACTDATA | CHAR (1) | Specifies what activity data should be collected by the applicable
event monitor.
|
|
COLLECTACTPARTITION | CHAR (1) | Specifies where activity data is collected.
|
|
COLLECTREQMETRICS | CHAR (1) | Specifies the monitoring level for requests submitted by a
connection that is associated with the service superclass.
|
|
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |