The Workloads tab on Workload Management Analysis drilldown shows real-time information about each workload defined on the current database. DB2 workloads are objects to which database connections are automatically assigned. Connection attributes determine to which workload a specific connection is assigned.
Once a connection is assigned to a workload, DB2 Workload Manager can apply thresholds and resource controls to manage the execution of activities in the workload. The Workload Manager can also collect data about individual database activities and about the workload as whole to help you troubleshoot performance issues currently occurring and to avoid similar issues in the future.
The tab lists the workloads currently defined in your Workload Manager environment on the database. These include both user-defined and system default workloads. Expand a workload node to view the following summary statistics collected for the workload at each database partition:
|
Coord Act. Queue Time Avg (DB2 9.7 and later) | ||
|
Coord Act. Queue Time Stddev (DB2 9.7 and later) | ||
|
Coord Act. Lifetime HWM (DB2 9.7 and later) |
| |
|
Coord Act. Lifetime Avg (DB2 9.7 and later) |
| |
|
Coord Act. Lifetime Stddev (DB2 9.7 and later) |
| |
|
Coord Act. Exec Time Avg (DB2 9.7 and later) |
| |
|
Coord Act. Exec Time Stddev (DB2 9.7 and later) |
|
To access in-depth information about a specific workload, click its entry and view any of the following sub-drilldowns:
Occurrences
Shows details and statistics for each occurrence in the workload (that is, each database connection assigned to this workload). View the attributes used to assign the connection to the workload, the current status of the occurrence, and the volume and success and failure rates of its activities.
Agents
Provides details about the agents handling activities associated with occurrences in this workload.
Threshold Queues
Lists statistics for queued activities across all occurrences in the workload. These statistics include queue times and sizes.
Workload Activity
Graphically depicts activity totals for the workload across all occurrences in the workload.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
