CA APM Cross-Enterprise Metrics › DB2 z/OS Subsystems Metrics › Workload

Workload

These workload metrics are reported for each monitored DB2 subsystem.

Aborts

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

Call Requests

Displays the number of SQL CALL statements that are issued during the last polling interval.

Create Thread Requests

Displays the number of successful create thread requests that the DB2 Subsystem Services component processed during the last polling interval.

Current Background Threads

Displays the current number of connections to DB2 from batch.

Current DBAT Threads

Displays the current number of active remote connections.

Current Foreground Threads

Displays the number of TSO connections in use as defined by the IDFORE DSNZPARM parameter.

Current Threads

Displays the current number of active users in DB2.

Delete Requests

Displays the number of SQL DELETE statements that are issued during the last polling interval.

Dynamic Requests

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

InsUpdDel Requests

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

Insert Requests

Displays the number of SQL INSERT statements that are issued during the last polling interval.

Maximum Background Threads

Displays the maximum number of concurrent connections that DB2 allows from batch.

Maximum Batch Users (%)

Displays the percentage of maximum batch connections in use as defined by the IDBACK DSNZPARM parameter.

Maximum DBAT Threads

Displays the maximum number of database access threads (DBATs) that can be allocated concurrently.

Maximum Foreground Threads

Displays the maximum number of users that are allowed to be identified to DB2 from the TSO foreground simultaneously.

Maximum Remote Users (%)

Displays the percentage of maximum remote connections in use as defined by the MAXDBAT DSNZPARM parameter.

Maximum TSO Users (%)

Displays the percentage of maximum TSO connections in use as defined by the IDFORE ZPARM parameter.

Maximum Threads

Displays the maximum number of allied threads (threads that are started at the local subsystem) that can be allocated concurrently.

Maximum Users (%)

Displays the percentage of maximum users currently active in DB2.

Queued Create Thread Requests

Displays the number of create threads the DB2 Subsystem Services component processes that have waited or were queued. This situation is because the maximum number of concurrent threads had been reached during the last polling interval.

SelectOpen Requests

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

Syncs

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

Update Requests

Displays the number of SQL UPDATE statements that are issued during the last polling interval.