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   This column is no longer used and will be removed in a future release.
PREFETCHPRIORITY CHAR (1)   Prefetch priority of the agents in the service class.
  • H = High
  • L = Low
  • M = Medium
  • Blank = not set
MAXDEGREE SMALLINT Y Possible values:
  • 1 - 32767 = Maximum degree of parallelism for the service class
  • -1 = MAXIMUM DEGREE NONE was specified for the service class
  • -2 = MAXIMUM DEGREE DEFAULT was specified for the service class
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 request 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 = Coordinator member of the activity
  • D = All members
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
CPUSHARES INTEGER   The number of CPU shares allocated to this service class.
CPUSHARETYPE CHAR (1)   Specifies the type of CPU shares.
  • S = Soft shares
  • H = Hard shares
CPULIMIT SMALLINT   The maximum percentage of the CPU resource that can be allocated to the service class; -1 if there is no CPU limit.
SORTMEMORYPRIORITY CHAR (1)   Reserved for future use.
SECTIONACTUALSOPTIONS VARCHAR (32)   Specifies what section actuals are collected during the execution of a section. The first position in the string represents whether the collection of section actuals is enabled.
  • B = Enabled and collect basic operator cardinality counts and statistics for each object referenced by the section (DML statements only).
  • N = Not enabled.
The second position is always 'N' and reserved for future use.
COLLECTAGGUOWDATA CHAR (1)   Specifies what aggregate unit of work data should be captured for the service class by the applicable event monitor.
  • B = Collect base aggregate unit of work data
  • N = None
RESOURCESHARES INTEGER

The number of shares of resources this service class is entitled to when workload manager (WLM) adaptive admission control is enabled. This value is relative to other service classes in the same scope.
RESOURCESHARETYPE CHAR (1)
Specifies the type of admission shares.
  • S = Soft shares
  • H = Hard shares
MINRESOURCESHAREPCT SMALLINT

Specifies the percentage (0 - 100) of entitled resources reserved by workload manager (WLM) adaptive admission control. WLM adaptive admission control holds these resources in reserve for the service class when other service classes exceed their admission resource entitlement.
ADMISSIONQUEUEORDER CHAR (1)
Specifies the order of the service class admission queue.
  • F = First in first out; queued requests are ordered based on the time in which they arrived.
  • L = Latency; queued requests are ordered based on their estimated execution time (latency) relative to the amount of time they have been queued.
  • Blank = Not applicable; this service class is a service superclass.
DEGREESCALEBACK CHAR (1)
Specifies if query degree for queries running with DEGREE ANY can be scaled back at runtime when the system is under high CPU load.
  • D = Degree scaleback value is inherited from the superclass. This is the default for a service subclass.
  • Y = Degree scaleback is enabled. This is the default for a service superclass.
  • N = Degree scaleback is disabled.
WORKLOADTYPE SMALLINT Y
Specifies the workload type for the service class.  
  • NULL = Service class is a subclass
  • 1 = Custom
  • 2 = Mixed
  • 3 = Interactive
  • 4 = Batch
COLLECTHISTORY CHAR (1) Y
Specifies whether activity data with details is collected at the coordinator member. If COLLECT ACTIVITY DATA is independently modified, this value is NULL.
  • Y = Activity data with details is collected at coordinator member
  • N = Activity data is not collected
ACTSORTMEMLIMIT INTEGER   The activity sort memory limit for queries executing in the service class. The default of 100 is shown if you do not specify a sort limit.
REMARKS VARCHAR (254) Y User-provided comments, or NULL.