MON_WORKLOAD_SUMMARY - Retrieves metrics for all workloads
The MON_WORKLOAD_SUMMARY administrative view returns key metrics for all workloads in the currently connected database.
This view is designed to help monitor the system in a high-level manner, showing incoming work per workload.
The metrics returned represent the accumulation of all metrics for requests that were submitted by connections mapped to the identified workload object across all members of the database.
The schema is SYSIBMADM.
Authorization
One of the following authorizations
is required:
- SELECT privilege on the MON_WORKLOAD_SUMMARY administrative view
- CONTROL privilege on the MON_WORKLOAD_SUMMARY administrative view
- DATAACCESS authority
Default PUBLIC privilege
None
Information returned
| Column name | Data type | Description or Monitor element |
|---|---|---|
| WORKLOAD_NAME | VARCHAR(128) | workload_name - Workload name |
| WORKLOAD_ID | INTEGER | workload_id - Workload ID |
| TOTAL_APP_COMMITS | BIGINT | total_app_commits - Total application commits monitor elements |
| TOTAL_APP_ROLLBACKS | BIGINT | total_app_rollbacks - Total application rollbacks monitor element |
| ACT_COMPLETED_TOTAL | BIGINT | act_completed_total - Total completed activities monitor element |
| APP_RQSTS_COMPLETED _TOTAL | BIGINT | Total number of external (application) requests that completed successfully across all members of the database for the specified service subclass |
| AVG_RQST_CPU_TIME | BIGINT | Average amount of CPU time, in microseconds, used by all external requests that completed successfully. It represents the total of both user and system CPU time. |
| ROUTINE_TIME_RQST_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent working on requests that was spent executing user routines. |
| RQST_WAIT_TIME_PERCENT | DECIMAL(5,2) | The percentage of the time spent working on requests that was spent waiting within the database server. |
| ACT_WAIT_TIME_ PERCENT | DECIMAL(5,2) | The percentage of the time spent executing activities that was spent waiting within the database server. |
| IO_WAIT_TIME_PERCENT | DECIMAL(5,2) | The percentage of the time spent waiting within the database server that was due to I/O operations. This includes time spent performing direct reads or direct writes, and time spent reading data and index pages from the table space to the bufferpool or writing them back to disk. |
| LOCK_WAIT_TIME_PERCENT | DECIMAL(5,2) | The percentage of time spent waiting within the database server that was spent waiting on locks. |
| AGENT_WAIT_TIME_PERCENT | DECIMAL(5,2) | The percentage of time spent waiting within the database server that was spent by an application queued to wait for an agent under concentrator configurations. |
| NETWORK_WAIT_TIME_PERCENT | DECIMAL(5,2) | The percentage of time spent waiting within the database server that was spent on client-server communications. This includes time spent sending and receiving data over TCP/IP or using the IPC protocol. |
| SECTION_PROC_TIME_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent actively working on requests that was spent executing sections. This includes the time spent performing sorts. |
| SECTION_SORT_PROC_TIME_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent actively working on requests that was spent performing sorts while executing sections. |
| COMPILE_PROC_TIME_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent actively working on requests that was spent compiling an SQL statement. This includes explicit and implicit compile times. |
| TRANSACT_END_PROC_TIME_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent actively working on requests that was spent performing commit processing or rolling back transactions. |
| UTILS_PROC_TIME_PERCENT | DECIMAL(5,2) | The percentage of time the database server spent actively working on requests that was spent running utilities. This includes performing runstats, reorganization, and load operations. |
| AVG_LOCK_WAITS_PER_ACT | BIGINT | The average number of times that applications or connections waited for locks per coordinator activities (successful and aborted). |
| AVG_LOCK_TIMEOUTS_PER_ACT | BIGINT | The average number of times that a request to lock an object timed out per coordinator activities (successful and aborted). |
| AVG_DEADLOCKS_PER_ACT | BIGINT | The average number of deadlocks per coordinator activities (successful and aborted). |
| AVG_LOCK_ESCALS_PER_ACT | BIGINT | The average number of times that locks have been escalated from several row locks to a table lock per coordinator activities (successful and aborted). |
| ROWS_READ_PER_ROWS_RETURNED | BIGINT | The average number of rows read from the table per rows returned to the application. |
| TOTAL_BP_HIT_RATIO_PERCENT | DECIMAL(5,2) | The percentage of time that the database manager did not need to load a page from disk to service a data request, index page request, or a request to process column-organized table data, including requests for XML storage objects (XDAs). In a Db2® pureScale® environment, this value represents the total hit ratio for the local bufferpool. |
| TOTAL_GBP_HIT_RATIO_PERCENT | DECIMAL(5,2) | In a Db2 pureScale environment, the percentage of time that the database manager did not need to load a page from disk into the local bufferpool to service a data request, index request, XML storage object (XDA) page request, or a request to process column-organized table data, as the page was located in the group bufferpool. Outside of a Db2 pureScale environment, this value will always be null. |
| TOTAL_CACHING_TIER_HIT_RATIO_PERCENT | DECIMAL(5,2) | Reserved for future use. |
| CF_WAIT_TIME_PERCENT | DECIMAL(5,2) | In a Db2 pureScale environment, the percentage of the total wait time spent waiting for caching facility communications. Outside of a Db2 pureScale environment, this value will always be null. |
| RECLAIM_WAIT_TIME_PERCENT | DECIMAL(5,2) | In a Db2 pureScale environment, the percentage of the total wait time spent waiting for page reclaims. Outside of a Db2 pureScale environment, this value will always be null. |
| SPACEMAPPAGE_RECLAIM_WAIT_TIME_PERCENT | DECIMAL(5,2) | In a Db2 pureScale environment, the percentage of the total wait time spent waiting for space map page reclaims. Outside of a Db2 pureScale environment, this value will always be null. |