Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Getting Started Guide

Workload Management Analysis drilldown - Service Classes tab

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.

Service Class Summary Details

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:


Con. Act. HWM

Coord Act. Queue Time Std . Dev .


Coord Act. LT HWM

Active Requests


Coord Act. LT Avg

Total Requests

Connection HWM

Coord Act. LT Std . Dev .

Req . Time Avg.

Coord Act. Compl .

Coord Act. Exec Time Avg.

Req . Time Std . Dev .

Coord Act. Aborted

Coord Act. Exec Time Std . Dev .

Req . Time Total

Coord Act. Rejected

Coord Act. Queue Time Avg.

Last Reset

Information About Specific Service Classes

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.)

Workload Occurrences
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.

Threshold Queues
Lists statistics for queued activities in all workloads in the service class. These statistics include queue times and sizes.

Class Activity
Graphically depicts activity totals for all workloads in the service class.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating