Cross-Enterprise APM Metrics › DB2 z/OS Data Sharing Group Metric Categories › Workload

Workload

These workload metrics are reported for each monitored DB2 Data Sharing Group:

Aborts

Displays the combined number of implicit and explicit ROLLBACKs (ABORTs) that the DB2 Subsystem Services component of member subsystems processed during the last polling interval.

Call Requests

Displays the combined number of SQL CALL statements that member subsystems issued during the last polling interval.

Create Thread Requests

Displays the combined number of successful CREATE THREAD requests that the DB2 Subsystem Services component of member subsystems processed during the last polling interval.

Current Background Threads

Displays the combined number of batch connections to DB2 in all member subsystems.

Current DBAT Threads

Displays the combined number of active remote connections in all member subsystems.

Current Foreground Threads

The combined number of TSO connections in use as defined by the IDFORE DSNZPARM parameter in all member subsystems.

Current Threads

Displays the combined number of active users in DB2 from all member subsystems.

Delete Requests

Displays the combined number of SQL DELETE statements that member subsystems issued during the last polling interval.

Dynamic Requests

Displays the combined number of SQL DESCRIBE and SQL PREPARE statements that member subsystems issued during the last polling interval.

InsUpdDel Requests

Displays the combined number of SQL INSERT, SQL UPDATE, and SQL DELETE statements that member subsystems issued during the last polling interval.

Insert Requests

Displays the combined number of SQL INSERT statements that member subsystems issued during the last polling interval.

Queued Create Thread Requests

Displays the combined number of CREATE THREAD requests that have waited or were queued during the last polling interval. The concurrent thread limit was reached.

SelectOpen Requests

Displays the combined number of SQL SELECT and SQL OPEN statements that member subsystems issued during the last polling interval.

Syncs

Displays the combined number of successful single phase COMMITs (SYNCs) that the DB2 Subsystem Services component of member subsystems processed during the last polling interval.

Update Requests

Displays the combined number of SQL UPDATE statements that member subsystems issued during the last polling interval.