The Service Classes tab on Workload Management Analysis drilldown shows real-time summary and drill-down information about each service class defined on the current database.
A DB2 service class is a database object, assigned to one or more workloads, which defines the execution environment in which the activities in a workload run. That is, the service class is the primary point from which resources for database requests are assigned, work flow is managed, and activities are monitored in a workload.
A workload is assigned to one service class in the workload definition. However, a service class can be assigned to multiple workloads.
The tab lists the service classes currently defined on the database. These include both user-defined and system default service classes. Each top-level node in the list is the service superclass , which serves as the top tier for managing work environments. Expand a service superclass node to view its subclasses. The different service subclasses provide granularity in mapping resources and applying controls. A subclass is the actual environment where workload activities run.
The following summary statistics are shown for each subclass at database-partition level:
To access in-depth information about what is happening across all workloads in your database at the service class level, click a service class entry and view any of the following sub-drilldowns. (Click a superclass to view information across all its subclasses; click a subclass to view information specific to the subclass.)
Shows details about occurrences (that is, database connections assigned to a workloads) currently running across all workloads assigned to the service class. For each occurrence, view the attributes used to assign the connection to its workload, the current status of the occurrence, and the volume and success and failure rates of its activities.
Provides details about the agents handling activities associated with occurrences across all workloads in the service class.
Lists statistics for queued activities in all workloads in the service class. These statistics include queue times and sizes.
Graphically depicts activity totals for all workloads in the service class.