DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.SERVICECLASSES catalog view

Each row represents a service class.

Table 1. SYSCAT.SERVICECLASSES Catalog View
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.
  • N = Disabled
  • Y = Enabled
AGENTPRIORITY SMALLINT   Thread priority of the agents in the service class relative to the normal priority of DB2® threads.
  • -20 to 20 (Linux and UNIX)
  • -6 to 6 (Windows)
  • -32768 = not set
PREFETCHPRIORITY CHAR (1)   Prefetch priority of the agents in the service class.
  • H = High
  • L = Low
  • M = Medium
  • Blank = not set
BUFFERPOOLPRIORITY CHAR (1)   Bufferpool priority of the agents in the service class
  • H = High
  • L = Low
  • M = Medium
  • Blank = Not set
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.
  • B = Collect base aggregate activity data
  • E = Collect extended aggregate activity data
  • N = None
COLLECTAGGREQDATA CHAR (1)   Specifies what aggregate activity data should be captured for the service class by the applicable event monitor.
  • B = Collect base aggregate request data
  • N = None
COLLECTACTDATA CHAR (1)   Specifies what activity data should be collected by the applicable event monitor.
  • D = Activity data with details
  • N = None
  • S = Activity data with details and section environment
  • V = Activity data with details and values
  • W = Activity data without details
  • X = Activity data with details, section environment, and values
COLLECTACTPARTITION CHAR (1)   Specifies where activity data is collected.
  • C = Database partition of the coordinator of the activity
  • D = All database partitions
COLLECTREQMETRICS CHAR (1)   Specifies the monitoring level for requests submitted by a connection that is associated with the service superclass.
  • B = Collect base request metrics
  • E = Collect extended request metrics
  • N = None
REMARKS VARCHAR (254) Y User-provided comments, or the null value.