range_adjustment - Range Adjustment monitor element

This value represents the offset into the container array in which a range actually starts.

Table 1. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_container_id - Range Container monitor element

An integer that uniquely defines a container within a range.

Table 3. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 4. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_end_stripe - End Stripe monitor element

This value represents the number of the last stripe in a range.

Table 5. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 6. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_max_extent - Maximum Extent in Range monitor element

This value represents the maximum extent number that is mapped by a range.

Table 7. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 8. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_max_page_number - Maximum Page in Range monitor element

This value represents the maximum page number that is mapped by a range.

Table 9. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 10. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_num_container - Number of Containers in Range monitor element

This value represents the number of containers in the current range.

Table 11. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 12. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_number - Range Number monitor element

This value represents the number of a range within the table space map.

Table 13. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 14. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_offset - Range Offset monitor element

The offset from stripe 0 of the beginning of the stripe set to which a range belongs.

Table 15. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 16. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_start_stripe - Start Stripe monitor element

This value represents the number of the first stripe in a range.

Table 17. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 18. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

range_stripe_set_number - Stripe Set Number monitor element

This value represents the stripe set in which a range resides.

Table 19. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges Always collected
Table 20. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_range Basic
Usage
This element is applicable only to a DMS table space.

reusability_status_reason - Reusability status reason monitor element

Identifies the reasons why the connection might not be reusable. Each reason is separated by a semi-colon.

Reasons for non-reusability are:
  • WITHHOLD_CURSOR - Connection has with hold cursor
  • DGTT - DGTTs are in use
  • CGTT - CGTTs with PRESERVE ROWS are in use
  • ENCRYPT_PASSWD - Connections are using encrypted passwords
  • TRANSFORM_GROUP - Transform Group Register is set
  • SESSION_AUTHID - SESSION AUTHID register was changed
  • SEQUENCES - Sequences are used without setting DB2_ALLOW_WLB_WITH_SEQUENCES registry variable
  • GLOBAL_VARS - Global variables in use
  • COLLECT_ACTIVITY - Activity collection is enabled for the connection by using the WLM_SET_CONN_ENV stored procedure
  • SECTION_ACTUALS - Section actuals were changed from the default for the connection by using the WLM_SET_CONN_ENV stored procedure
  • DYNAMIC_SQL - Connection reuse is blocked because Dynamic SQL is used
Table 22. Table function monitoring information
Table function Monitor element collection level
MON_GET_CONNECTION table function - Get connection metrics Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics Always collected

rebalancer_extents_processed - Number of extents the rebalancer has processed monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_extents_processed element.

The number of extents that the rebalancer has already moved since the rebalancer has been started or restarted (whichever is most recent).

Table 23. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 24. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This can be used as an indicator of the completion level of the rebalancer. You can monitor the progress of rebalancing by keeping track of the change in this element over time. You can use tablespace_state and rebalance_mode to check if the rebalancing is completed. This is only applicable to a DMS table space.

rebalancer_extents_remaining - Total number of extents to be processed by the rebalancer monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_extents_remaining element.

The number of extents to be moved. This value is calculated at either the rebalancer start time or restart time (whichever is most recent).

Table 25. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 26. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This element can be used as an indicator of the completion level of the rebalancer. You can monitor the progress of rebalancing by keeping track of the change in this element over time. You can use tablespace_state to check if rebalancing has completed. This is only applicable to a DMS table space.

rebalancer_last_extent_moved - Last extent moved by the rebalancer monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_last_extent_moved element.

The last extent moved by the rebalancer.

Table 27. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 28. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This can be used as an indicator of the completion level of the rebalancer. You can monitor the progress of rebalancing by keeping track of the change in this element over time. You can use tablespace_state and rebalance_mode to check if the rebalancing is completed. This is only applicable to a DMS table space.

rebalancer_mode - Rebalancer mode monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_mode element.

Indicates whether the current rebalance process is removing space from a table space or adding space to a table space.

Table 29. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
MON_GET_TABLESPACE table function - Get table space metrics Always collected
Table 30. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic

Usage

A forward rebalance occurs when new containers are added or existing containers have their size increased. In a forward rebalancing operation, data movement starts with the first extent in the table space and ends with the high watermark extent.

A reverse rebalance occurs when containers are removed or reduced in size and data needs to move out of the space being freed. In a reverse rebalancing operation, data movement starts at the high watermark extent and moves in reverse order through the table space, ending with the first extent in the table space.

A two-pass rebalance is a forward rebalance followed by a reverse rebalance. A two-pass rebalance might occur when containers are being both added and dropped as part of the rebalance operation.

For DMS non-automatic storage table spaces, this monitor element indicates the type of rebalance that is occurring for the table space. Only a single forward rebalance or a single reverse rebalance can occur for DMS non-automatic table space.

For automatic storage table spaces, this monitor element indicates what the current rebalance process is doing to the table space. In general, only a single forward rebalance or a single reverse rebalance is necessary when a rebalance is initiated. However, there are cases when a two-pass rebalance is necessary for automatic storage table spaces.

The possible tablespace_rebalancer_mode values are defined in the sqlmon.h file. The following values are returned in snapshot monitoring:
SQLM_TABLESPACE_NO_REBAL
No rebalancing is taking place.
SQLM_TABLESPACE_FWD_REBAL
Forward rebalance is taking place.
SQLM_TABLESPACE_REV_REBAL
Reverse rebalance is taking place.
SQLM_TABLESPACE_FWD_REBAL_OF_2PASS
The forward rebalance phase of two pass rebalance is taking place.
SQLM_TABLESPACE_REV_REBAL_OF_2PASS
The reverse rebalance phase of two pass rebalance is taking place.
If using either the MON_GET_TABLESPACE or the MON_GET_REBALANCE_STATUS table function, the following rebalancer_mode values are returned:
  • NO_REBAL
  • FWD_REBAL
  • REV_REBAL
  • FWD_REBAL_OF_2PASS
  • REV_REBAL_OF_2PASS

rebalancer_priority - Current rebalancer priority monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_priority element.

The priority at which the rebalancer is running in the database.

Table 31. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 32. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This is only applicable to a DMS table space.

rebalancer_restart_time - Rebalancer restart time monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_restart_time element.

A timestamp representing when a rebalancer was restarted after being paused or suspended.

Table 33. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 34. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This can be used as an indicator of the completion level of the rebalancer. It will note when the rebalancer was restarted, and will allow for the derivation of the speed of the rebalancer and the estimated time until completion. This is only applicable to a DMS table space.

rebalancer_source_storage_group_id - Rebalancer source storage group identifier monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_source_storage_group_id element.

The source storage group identifier if the rebalancer is moving a table space from one storage group to another. Otherwise, it is -1.

Table 35. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - Get rebalance progress for a table space Always collected

rebalancer_source_storage_group_name - Rebalancer source storage group name monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_source_storage_group_name element.

The source storage group name if the rebalancer is moving a table space from one storage group to another. Otherwise, it is NULL.

Table 36. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - Get rebalance progress for a table space Always collected

rebalancer_start_time - Rebalancer start time monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_start_time element.

A timestamp representing when a rebalancer was initially started.

Table 37. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
Table 38. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This will be used to note the time at which a rebalancer was initially started. This can be used to derive metrics as to the speed at which the rebalancer is operating, and the estimated time of completion of the rebalance. This is only applicable to a DMS table space.

rebalancer_status - Rebalancer status monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_status element.

Indicates the current status of the rebalance operation.

Table 39. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected

Usage note

Current status of the rebalance operation is one of:
  • ACTIVE - Rebalance operation is active.
  • SUSPENDED - Rebalance operation has been explicitly suspended by a user using the ALTER TABLESPACE statement.
  • PAUSED - Rebalance operation has been implicitly paused due to an online backup. The rebalance will proceed when the backup is complete.

If the rebalance operation has been explicitly suspended and implicitly paused, the status is reported as SUSPENDED.

rebalancer_target_storage_group_id - Rebalancer target storage group identifier monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_target_storage_group_id element.

The target storage group identifier if the rebalancer is moving a table space from one storage group to another. Otherwise, it is -1.

Table 40. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - Get rebalance progress for a table space Always collected

This monitor element is connected to the target_storage_group_name monitor element, as well as source_storage_group_id monitor element and source_storage_group_name monitor element. You use these elements together to understand if a rebalance operation is moving a tablespace from one storage group to another, and to understand which storage group the tablespace is moving from (the source) and where it is moving to (the target).

rebalancer_target_storage_group_name - Rebalancer target storage group name monitor element

Note: This monitor element is an alias for the tablespace_rebalancer_target_storage_group_name element.

The target storage group name if the rebalancer is moving a table space from one storage group to another. Otherwise, it is NULL.

Table 41. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_REBALANCE_STATUS table function - Get rebalance progress for a table space Always collected

reclaim_wait_time - Reclaim wait time monitor element

In a Db2® pureScale® environment, this element represents the amount of time spent waiting on page locks, where the lock request caused a page to be reclaimed. The unit of measurement for time is in milliseconds.

Table 42. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PAGE_ACCESS_INFO table function - Get buffer pool page waiting information Always collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - Get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 43. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity (reported in the details_xml document) ACTIVITY METRICS BASE
Activities event_activitymetrics ACTIVITY METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_superclassstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

Usage

The time spent waiting for reclaims on space map pages is counted separately and reported in the spacemappage_reclaim_wait_time monitor element.

regvar_collection_type - Registry variable collection type monitor element

Indicates when the registry variable value was collected.

Table 45. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change History REGVAR Always collected

Usage

The change history event monitor collected this value as:
I
The initial value that was captured when the event monitor was activated.
U
Updated value

regvar_level - Registry variable level monitor element

Indicates the level of the registry variable.

Table 46. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change History REGVAR Always collected

Usage

For the change history event monitor, the level of the registry variable is one of:
E
Environment
G
Global
I
Instance-level
P
Database partition

regvar_name - Registry variable name monitor element

The name of the registry variable.

Table 47. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change History REGVAR Always collected

Usage

For the change history event monitor, this element identifies the registry variable that was updated as part of a REGVAR event, or captured at event monitor startup as part of a REGVARVALUES event. These events represent the following:
REGVAR
Changing a registry variable value
REGVARVALUES
Capturing registry variable values at event monitor startup

regvar_old_value - Registry variable old value monitor element

The old value for the registry variable.

Table 48. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change History REGVAR Always collected

Usage

For the change history event monitor, if the registry variable value was not set, this value is an empty string.

regvar_value - Registry variable value monitor element

This is the value for the registry variable.

Table 49. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change History REGVAR Always collected

Usage

For the change history event monitor, if the value was not set, this value is an empty string.

Only immediate registry variable updates generate REGVAR events.

rej_curs_blk - Rejected Block Cursor Requests monitor element

The number of times that a request for an I/O block at server was rejected and the request was converted to non-blocked I/O.

Element identifier
rej_curs_blk
Element type
counter
Table 50. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl Basic
Table 51. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Connection event_conn Always collected
Usage
If there are many cursors blocking data, the communication heap may become full. When this heap is full, an error is not returned. Instead, no more I/O blocks are allocated for blocking cursors. If cursors are unable to block data, performance can be affected.
If a large number of cursors were unable to perform data blocking, you may be able to improve performance by:
  • Increasing the size of the query_heap database manager configuration parameter.

rem_cons_in - Remote Connections To Database Manager monitor element

The current number of connections initiated from remote clients to the instance of the database manager that is being monitored.

Table 52. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic

Usage

Shows the number of connections from remote clients to databases in this instance. This value will change frequently, so you may need to sample it at specific intervals over an extended period of time to get a realistic view of system usage. This number does not include applications that were initiated from the same instance as the database manager.

When used in conjunction with the local_cons monitor element, these elements can help you adjust the setting of the max_coordagents and max_connections configuration parameters.

rem_cons_in_exec - Remote Connections Executing in the Database Manager monitor element

The number of remote applications that are currently connected to a database and are currently processing a unit of work within the database manager instance being monitored.

Table 53. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic

Usage

This number can help you determine the level of concurrent processing occurring on the database manager. This value will change frequently, so you may need to sample it at specific intervals over an extended period of time to get a realistic view of system usage. This number does not include applications that were initiated from the same instance as the database manager.

When used in conjunction with the local_cons_in_exec monitor element, this element can help you adjust the setting of the max_coordagents configuration parameter.

If max_coordagents is set to AUTOMATIC, then you do not need to make any adjustments. If it is not set to AUTOMATIC and if the sum of rem_cons_in_exec and local_cons_in_exec is close to max_coordagents, you should increase the value of max_coordagents.

remote_lock_time - Remote Lock Time monitor element

This element contains the aggregate amount of time, in milliseconds, that this data source spends in a remote lock from all applications or a single application running on this federated server instance since the start of the federated server instance or the last reset of the database monitor counters. The monitor stores the most recent of these values. The response time is measured as the difference between the time the federated server submits a remote lock to the data source, and the time the federated server releases a remote lock at the data source.
Table 54. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase_remote Timestamp
Application appl_remote Timestamp
For snapshot monitoring, this counter can be reset.

Usage

Use this element to determine how much actual time is spent at this data source in a remote lock.

remote_locks - Remote Locks monitor element

This element contains a count of the total number of remote locks that the federated server has called at this data source on behalf of any application since the start of the federated server instance or the last reset of the database monitor counters, whichever is latest.

Table 55. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase_remote Basic
Application appl_remote Basic
For snapshot monitoring, this counter can be reset.
Usage
Use this element to determine how many remote locks were made remotely at the data source.

remote_member - Remote member monitor element

The numeric identifier for the database member to which data was sent or from which data was received, using the fast communication manager (FCM).

Table 56. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections Always collected

Usage

All the metrics returned by the MON_GET_FCM_CONNECTION_LIST table function apply to the FCM connection between the members described in the member and remote_member monitor elements.

remote_storage_tier_write_bytes - Bytes to write to remote storage tier monitor element

The number of bytes written to remote storage for remote table spaces.

Attention: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
Table 57. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_BUFFERPOOL table function - Get buffer pool metrics DATA OBJECT METRICS BASE
MON_GET_DATABASE table function - Get database level information DATA OBJECT METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics DATA OBJECT METRICS BASE
MON_GET_TABLESPACE table function - Get table space metrics DATA OBJECT METRICS BASE

remote_storage_tier_write_reqs - Write requests to remote storage monitor element

The number of write requests to the remote storage for remote table spaces.

Attention: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
Table 58. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_BUFFERPOOL table function - Get buffer pool metrics DATA OBJECT METRICS BASE
MON_GET_DATABASE table function - Get database level information DATA OBJECT METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics DATA OBJECT METRICS BASE
MON_GET_TABLESPACE table function - Get table space metrics DATA OBJECT METRICS BASE

remote_storage_tier_write_time - Elapsed time to write to remote storage monitor element

The elapsed time, in milliseconds, to write to remote storage tier storage for remote table spaces.

Attention: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
Table 59. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_BUFFERPOOL table function - Get buffer pool metrics DATA OBJECT METRICS BASE
MON_GET_DATABASE table function - Get database level information DATA OBJECT METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics DATA OBJECT METRICS BASE
MON_GET_TABLESPACE table function - Get table space metrics DATA OBJECT METRICS BASE

remote_update_time - Remote member update time monitor element

During extent movement, this monitor element shows the cumulative time spent waiting for remote members to update cached page locations for moved extents on remote members.

The value is given in milliseconds.

Table 60. Table function monitoring information
Table function Monitor element collection level
MON_GET_EXTENT_MOVEMENT_STATUS - get extent movement progress Always collected

reopt - Reopt bind option monitor element

The REOPT bind option used to precompile this package. Possible values are: NONE, ONCE, and ALWAYS.

Table 61. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking lock_participant_activities  

reorg_completion - Reorganization Completion Flag monitor element

Table reorganization success indicator, which includes the reclamation of extents from a multidimensional clustering (MDC) or insert time cluserting (ITC) table. For partitioned tables, this value indicates the completion status for the data partition.

Table 62. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic
Usage
This element will have a value of 0 if a table or data partition reorganize operation is successful. If a table or data partition reorganize operation is unsuccessful, this element will have a value of -1. Success and failure values are defined in sqlmon.h as follows:
  • Success: SQLM_REORG_SUCCESS
  • Failure: SQLM_REORG_FAIL

In the case of an unsuccessful table reorganization, see the history file for any diagnostic information, including warnings and errors. This data can be accessed by using the LIST HISTORY command. For partitioned tables, the completion status is indicated per data partition. If index re-create fails on a partitioned table, the failed status is updated on all data partitions. See the administration notification log for further diagnostic information.

reorg_current_counter - Reorganize Progress monitor element

A unit of progress that indicates the amount of reorganization that has been completed. The amount of progress this value represents is relative to the value of reorg_max_counter, which represents the total amount of table reorganization that is to be done.

Table 63. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

Usage

You can determine the percentage of table reorganization that has been completed using the following formula: 
table reorg progress = reorg_current_counter / reorg_max_counter * 100

reorg_end - Table Reorganize End Time monitor element

The end time of a table reorganization including a reorganization to reclaim extents from a multidimensional clustering (MDC) or insert time clustering (ITC) table. For partitioned tables, this time indicates the end time for each data partition reorganization.

Table 64. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_index_id - Index Used to Reorganize the Table monitor element

The index being used to reorganize the table.

Table 65. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_long_tbspc_id - Table Space Where Long Objects are Reorganized monitor element

The table space in which any long objects (LONG VARCHAR or LOB data) will be reorganized. For partitioned tables, this is the table space in which each partition's LONG VARCHAR and LOB will be reorganized.

Table 66. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_max_counter - Total Amount of Reorganization monitor element

A value that indicates the total amount of work to be done in a reorganization. This value includes a reorganization to reclaim extents from multidimensional clustering (MDC) or insert time clustering (ITC) tables. This value can be used with reorg_current_counter, which represents the amount of work completed, to determine the progress of a reorganization.
Table 67. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_max_phase - Maximum Reorganize Phase monitor element

The maximum number of reorganization phases that occurs during reorganization processing. This number applies to classic (offline) reorganizations and to reorganizations with the RECLAIM EXTENTS option. The range of values is 2 - 4 ([SORT], BUILD, REPLACE,[INDEX_RECREATE]). The value could also indicate the total amount of work to be done in a reorganization to reclaim extents from a multidimensional clustering (MDC) or insert time clustering (ITC) table. When such a reorganization occurs, this value is 3 (SCAN, DRAIN, RELEASE).
Table 68. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_phase - Table reorganization phase monitor element

Indicates the reorganization phase of the table. For partitioned tables, this will also indicate the reorganization phase for each data partition. This applies to offline table reorganizations only.

Table 69. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

Usage

For partitioned tables, the reorganization occurs on a data partition by data partition basis. For classic table reorganization, the following phases are possible (phases are listed with their corresponding defines from thesqlmon.h file):
  • Sort: SQLM_REORG_SORT
  • Build: SQLM_REORG_BUILD
  • Replace: SQLM_REORG_REPLACE
  • Index Recreate: SQLM_REORG_INDEX_RECREATE
  • Dictionary Build: SQLM_REORG_DICT_SAMPLE

For partitioned tables, the Index Recreate phase for partitioned indexes (if any) might be directly entered after the replace phase for that data partition. The reorg_phase element will indicate the Index Recreate phase only after the successful completion of all prior phases on every data partition.

During XDA object compression, the XML data reorganization phase involves reorganizing the XML storage object of the table. The XML dictionary build phase involves attempting to create a compression dictionary for the XML storage object. For XDA object compression, the following two phases are possible:
  • XML Reorg: SQLM_REORG_XML_DATA
  • XML Dictionary Build: SQLM_REORG_XML_DICT_SAMPLE
For partitioned tables, where reclamation of extents is being performed, the following phases are possible:
  • Scan: SQLM_REORG_SCAN
  • Drain: SQLM_REORG_DRAIN
  • Release: SQLM_REORG_RELEASE

reorg_phase_start - Reorganize Phase Start Time monitor element

The start time of a phase of table reorganization or reclaim reorganization. For partitioned tables, this will also indicate the start time of a reorganization phase for each data partition. During the index re-create phase, data groups for all data partitions are updated at the same time for nonpartitioned indexes.

Table 70. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_rows_compressed - Rows Compressed monitor element

Number of rows compressed in the table during reorganization.

Table 71. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic
Usage
A running count of the number of rows compressed in the table during reorganization. Some records may never be compressed (if the record size is less than the minimum record length).

It is important to note that this row count does not measure the effectiveness of data compression. It only displays the number of records meeting compression criteria.

reorg_rows_rejected_for_compression - Rows Rejected for Compression monitor element

Number of rows that were not compressed during reorganization due to the record length being less than or equal to the minimum record length.

Table 72. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic
Usage
A record will not be compressed if it is less than or equal to the minimum record length. The number of rows rejected reflects a running count for these records that fail to meet this compression requirement.

reorg_start - Table Reorganize Start Time monitor element

The start time of a table reorganization including a reorganization to reclaim extents from a multidimensional clustering (MDC) or insert time clustering (ITC) table. For partitioned tables, this indicates the start time for each data partition reorganization.

Table 73. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_status - Table Reorganize Status monitor element

The status of an in-place (online) table or a data partition level reorganization. This is not applicable to classic (offline) table reorganizations.

Table 74. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic
Usage
An in-place table or data partition reorganization can be in one of the following states (states are listed with their corresponding defines from sqlmon.h):
  • Started/Resumed: SQLM_REORG_STARTED
  • Paused: SQLM_REORG_PAUSED
  • Stopped: SQLM_REORG_STOPPED
  • Completed: SQLM_REORG_COMPLETED
  • Truncate: SQLM_REORG_TRUNCATE
An inplace table or data partition reorganization to reclaim extents can be in one of the following states:
  • Started: SQLM_REORG_STARTED
  • Stopped: SQLM_REORG_STOPPED
  • Completed: SQLM_REORG_COMPLETED

reorg_tbspc_id - Table Space Where Table or Data partition is Reorganized monitor element

The table space in which the table will be reorganized. For partitioned tables, this indicates the table space where each data partition is reorganized.

Table 75. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_type - Table Reorganize Attributes monitor element

Table reorganize attribute settings.

Table 76. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic
Usage
The following are possible attribute settings. Each attribute setting is based upon a bit flag value defined in db2ApiDf.h.
  • Allow Write Access: DB2REORG_ALLOW_WRITE
  • Allow Read Access: DB2REORG_ALLOW_READ
  • Allow No Access: DB2REORG_ALLOW_NONE
  • Recluster Via Index Scan: DB2REORG_INDEXSCAN
  • Reorg Long Field LOB Data: DB2REORG_LONGLOB
  • No Table Truncation: DB2REORG_NOTRUNCATE_ONLINE
  • Replace Compression Dictionary: DB2REORG_RESET_DICTIONARY
  • Keep Compression Dictionary: DB2REORG_KEEP_DICTIONARY
  • Reclaim Extents: DB2REORG_RECLAIM_EXTS
In addition to the preceding attribute settings, the following attributes are listed in the CLP output of the GET SNAPSHOT FOR TABLES command. These attribute settings are based on the values of other attribute settings or table reorganize monitor elements.
  • Reclustering: If the value of the reorg_index_id monitor element is non-zero, then the table reorganize operation has this attribute.
  • Reclaiming: If the value of the reorg_index_id monitor element is zero, then the table reorganize operation has this attribute.
  • Inplace Table Reorg: If the reorg_status monitor element has a value that is not null, then the in-place (online) reorganization method is in use.
  • Table Reorg: If the reorg_phase monitor element has a value that is not null, then the classic (offline) reorganization method is in use.
  • Recluster Via Table Scan: If the DB2REORG_INDEXSCAN flag is not set, then the table reorganize operation has this attribute.
  • Reorg Data Only: If the DB2REORG_LONGLOB flag is not set, then the table reorganize operation has this attribute.

reorg_xml_regions_compressed - XML regions compressed monitor element

Number of XML regions that were compressed during the table reorganization process.

Table 77. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

reorg_xml_regions_rejected_for_compression - XML regions rejected for compression monitor element

Number of XML regions that were not compressed during the table reorganization process.

Table 78. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table_reorg Basic

req_executable_id - Identifier for statement section waiting to acquire lock monitor element

The binary token generated on the data server that uniquely identifies the SQL statement section which is waiting to acquire a lock. For non-SQL activities, a 0-length string value is returned.

Table 82. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_APPL_LOCKWAIT table function - get information about locks for which an application is waiting Always collected

request_exec_time_avg - Request execution time average monitor element

Arithmetic mean of the execution times for requests associated with this service subclass since the last reset. If the internally tracked average has overflowed, the value -2 is returned. This monitor element returns -1 when COLLECT AGGREGATE REQUEST DATA for the service subclass is set to NONE. Units are milliseconds.

When you remap activities between service subclasses with a REMAP ACTIVITY action, the request_exec_time_avg mean counts the partial request in each subclass involved in remapping.

Table 84. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses ACTIVITY METRICS BASE
WLM_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses COLLECT AGGREGATE REQUEST DATA
Table 85. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats -

Usage

Use this statistic to quickly understand the average amount of time that is spent processing each request on a member in this service subclass.

This average can also be used to determine whether or not the histogram template used for the request execution time histogram is appropriate. Compute the average request execution time from the request execution time histogram. Compare the computed average with this monitor element. If the computed average deviates from the true average reported by this monitor element, consider altering the histogram template for the request execution time histogram, using a set of bin values that are more appropriate for your data.

req_tenant_id - Requestor tenant identifier monitor element

The identifier of the tenant for the requestor of the lock.
Table 86. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_APPL_LOCKWAIT table function - returns index information Always collected

Usage

Use this element to identify the requestor tenant in which this RUNSTATS job is queued.

req_tenant_name - Requestor tenant name monitor element

The name of the tenant for the requestor of the lock

Table 87. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_APPL_LOCKWAIT table function - returns index information Always collected

Usage

Use this element to find the name of the requestor tenant in which this RUNSTATS job is queued.

RESOURCE_ENTITLEMENT monitor element

The resource entitlement for this service subclass, superclass, or workload.

Table 88. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_WORKLOAD_STATS table function - Return workload statistics Always collected
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 89. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected
Statistics event_superclassstats Always collected

RESOURCE_SHARES monitor element

The resource shares for this service subclass or superclass.

Table 90. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 91. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected

RESOURCE_SHARE_TYPE monitor element

The resource shares type for this service subclass or superclass.

Table 92. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 93. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected
Statistics event_superclassstats Always collected

rf_log_num - Log being rolled forward monitor element

The log being processed in the rollforward operation.

Table 94. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space rollforward Basic

Usage

If a rollforward is in progress, this element identifies the log involved. In a Db2 pureScale environment, the rf_log_num monitor element identifies the log file from each log stream that is currently involved in the rollforward operation.

rf_status - Log Phase monitor element

The status of the recovery.

Element identifier
rf_status
Element type
information
Table 95. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space rollforward Basic
Usage
This element indicates the progression of a recovery. It indicates if the recovery is in an undo (rollback) or redo (rollforward) phase.

rf_timestamp - Rollforward Timestamp monitor element

The timestamp of the last committed transaction..

Element identifier
rf_timestamp
Element type
timestamp
Table 96. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space rollforward Timestamp
Usage
If a rollforward is in progress, this is the timestamp of the last committed transaction processed by rollforward recovery. This is an indicator of how far the rollforward operation has progressed.

rf_type - Rollforward Type monitor element

The type of rollforward in progress.

Element identifier
rf_type
Element type
information
Table 97. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space rollforward Basic
Usage
An indicator of whether recovery is happening at a database or table space level.

rollback_sql_stmts - Rollback Statements Attempted monitor element

The total number of SQL ROLLBACK statements that have been attempted.

Element identifier
rollback_sql_stmts
Element type
counter
Table 98. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Database dbase_remote Basic
Application appl Basic
Application appl_remote Basic
DCS Database dcs_dbase Basic
DCS Application dcs_appl Basic
For snapshot monitoring, this counter can be reset.
Table 99. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Connection event_conn Always collected
Usage
A rollback can result from an application request, a deadlock, or an error situation. This element only counts the number of rollback statements issued from applications.

At the application level, this element can help you determine the level of database activity for the application and the amount of conflict with other applications. At the database level, it can help you determine the amount of activity in the database and the amount of conflict between applications on the database.

Note: You should try to minimize the number of rollbacks, since higher rollback activity results in lower throughput for the database.
It may also be used to calculate the total number of units of work, by calculating the sum of the following expression: 
 
   commit_sql_stmts
 + int_commits
 + rollback_sql_stmts
 + int_rollbacks

rolled_back_agent_id - Rolled Back Agent monitor element

Agent that was rolled back when a deadlock occurred.

Element identifier
rolled_back_agent_id
Element type
information
Table 100. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_deadlock Always collected
Usage
A system administrator can use this information to determine which application did not complete its updates, and determine which applications should be restarted.

rolled_back_appl_id - Rolled Back Application monitor element

Application id that was rolled back when a deadlock occurred.

Element identifier
rolled_back_appl_id
Element type
information
Table 101. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_deadlock Always collected
Usage
A system administrator can use this information to determine which application did not complete its updates, and determine which applications should be restarted.

rolled_back_participant_no - Rolled back application participant monitor element

The participant number identifying the rolled back application.

Table 102. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - Always collected
Deadlocks1 event_deadlock Always collected
1
This event monitor has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR for locking statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

A system administrator can use this information to determine which application did not complete its updates, and determine which application should be started.

rolled_back_sequence_no - Rolled Back Sequence Number monitor element

The sequence number of the application that was rolled back when a deadlock occurred.

Element identifier
rolled_back_sequence_no
Element type
information
Table 103. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_deadlock Always collected
Usage
A system administrator can use this information to determine which application did not complete its updates, and determine which applications should be restarted.

routine_id - Routine ID monitor element

A unique routine identifier. This monitor element returns 0 if the activity is not part of a routine.

Table 105. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in the DETAILS XML document) Always collected
MON_GET_AGENT table function - List agents, fenced mode processes, and system entities for the database Always collected
MON_GET_PKG_CACHE_STMT Always collected
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries Always collected
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_SECTION_ROUTINE table function - get list of routines for input section Always collected
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class Always collected
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities Always collected
Table 106. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activitystmt Always collected
Unit of work uow_package_list Always collected
Package cache pkgcache_metrics Always collected

Usage

The value of this element matches a value from column ROUTINEID of view SYSCAT.ROUTINES. When the activity is part of an SQL PL routine that you declare in another SQL PL routine, the value of this element is the ROUTINEID of the outer routine.

routine_module_name - Routine module name monitor element

Unqualified name of the module to which the routine belongs.

This element is NULL when the routine does not belong to a module.
Table 107. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_SECTION_ROUTINE table function - get list of routines for input section Always collected

routine_name - Routine name monitor element

Unqualified name of the routine.

This element might be system generated for subroutines and dynamically prepared compound SQL statements or anonymous blocks in PL/SQL.
Table 108. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_SECTION_ROUTINE table function - get list of routines for input section Always collected

routine_schema - Routine schema monitor element

Schema name of the routine when the routine does not belong to a module, otherwise this is the schema name of the module to which the routine belongs.

This element might be system generated for subroutines and dynamically prepared compound SQL statements or anonymous blocks in PL/SQL.
Table 109. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_SECTION_ROUTINE table function - get list of routines for input section Always collected

routine_type - Routine type monitor element

Identifies the type of routine.

The routine type can be one of the following:
C
Dynamically prepared compound SQL statement or PL/SQL anonymous block
F
Function
P
Procedure
T
Trigger
Table 110. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_SECTION_ROUTINE table function - get list of routines for input section Always collected

rows_deleted - Rows deleted monitor element

This is the number of row deletions attempted.

Table 111. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated execution metrics for routines REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 112. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Database dbase_remote Basic
Application appl Basic
Application appl_remote Basic
For snapshot monitoring, this counter can be reset.
Table 113. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Connection event_conn Always collected
Database event_db Always collected
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmmetrics REQUEST METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE
Usage
You can use this element to gain insight into the current level of activity within the database.

This count does not include the attempts counted in the int_rows_deleted monitor element.

rows_fetched - Rows fetched monitor element

The number of rows read from the table.

This monitor element is an alias of the rows_read monitor element.

Note: This monitor element reports only the values for the member for which this information is recorded. In multi member database environments, these values might not reflect the correct totals for the whole activity.
Table 114. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity ACTIVITY METRICS BASE

Usage

See the rows_read monitor element for details.

rows_inserted - Rows inserted monitor element

The number of row insertions attempted.

Table 115. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated execution metrics for routines REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 116. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Database dbase_remote Basic
Application appl Basic
Application appl_remote Basic
For snapshot monitoring, this counter can be reset.
Table 117. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Connection event_conn Always collected
Database event_db Always collected
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmmetrics REQUEST METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE
Usage
You can use this element to gain insight into the current level of activity within the database.

In a federated system, multiple rows can be inserted, per INSERT statement, because the federated server can push INSERT FROM SUBSELECT to the data source, when appropriate.

This count does not include the attempts counted in the int_rows_inserted monitor element.

rows_modified - Rows modified monitor element

The number of rows inserted, updated, or deleted.

This monitor element is an alias of the rows_written monitor element.

This monitor element includes activity for rows in permanent tables and temporary tables. It is possible in certain circumstances for its value to be greater than the sum of the monitor elements rows_inserted, rows_updated, and rows_deleted.

Table 118. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 119. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity (reported in the details_xml document) ACTIVITY METRICS BASE
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_superclassstats REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE
Unit of work Reported in the system_metrics document. REQUEST METRICS BASE
Activities event_activity ACTIVITY METRICS BASE
Package cache Reported in the activity_metrics document. ACTIVITY METRICS BASE

Usage

See the rows_written monitor element for details.

rows_read - Rows read monitor element

The number of rows read from the table.

Table 120. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine ACTIVITY METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 121. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Table table Table
Application appl Basic
Application stmt Basic
Application subsection Statement
Dynamic SQL dynsql Statement
For snapshot monitoring, this counter can be reset.
Table 122. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity (reported in the details_xml document) ACTIVITY METRICS BASE
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_superclassstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE
Unit of work Reported in the system_metrics document. REQUEST METRICS BASE
Connection event_conn Always collected
Tables event_table Always collected
Statements event_stmt Always collected
Transactions event_xact Always collected
Package cache Reported in the activity_metrics document. ACTIVITY METRICS BASE

Usage

This element helps you identify tables with heavy usage for which you may want to create additional indexes. To avoid the maintenance of unnecessary indexes, use the SQL EXPLAIN statement to determine if the package uses an index.

This count is not the number of rows that were returned to the calling application. Rather, it is the number of rows that had to be read in order to return the result set. For example, the following statement returns one row to the application, but many rows are read to determine the average salary: 
 
     SELECT AVG(SALARY) FROM USERID.EMPLOYEE

This count includes the value in the overflow_accesses monitor element. Additionally, this count does not include any index accesses. That is, if an access plan uses index access only and the table is not touched to look at the actual row, then the value of the rows_read monitor element is not incremented.

rows_returned - Rows returned monitor element

The rows_returned monitor element is the number of rows that have been selected and returned to the application. This element has a value of 0 for partial activity records (for example, if an activity is collected while it is still executing or when a full activity record could not be written to the event monitor due to memory limitations).

This monitor element is an alias of the fetch_count monitor element.

Table 123. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities REQUEST METRICS BASE
Table 124. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity (reported in the details_xml document) ACTIVITY METRICS BASE
Activities event_activitymetrics ACTIVITY METRICS BASE
Package cache Reported in the activity_metrics document. ACTIVITY METRICS BASE
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_superclassstats REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE
Unit of work Reported in the system_metrics document. REQUEST METRICS BASE

Usage

This element can be used to help determine thresholds for rows returned to the application or can be used to verify that such a threshold is configured correctly and doing its job.

rows_returned_top - Actual rows returned top monitor element

The rows_returned_top monitor element is the high watermark for the actual rows returned of DML activities at all nesting levels in a service class or work class. For service classes, this monitor element returns -1 when COLLECT AGGREGATE ACTIVITY DATA for the service class is set to NONE. For work classes, this monitor element returns -1 if no COLLECT AGGREGATE ACTIVITY DATA work action is specified for the work class. For workloads, this monitor element returns -1 when COLLECT AGGREGATE ACTIVITY DATA for the workload is set to NONE.

For service classes, when you remap activities between service subclasses with a REMAP ACTIVITY action, only the rows_returned_top high watermark of the service subclass where an activity completes is updated. High watermarks of service subclasses an activity is mapped to but does not complete in are unaffected.

Table 125. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 126. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats -
Statistics event_superclassstats -
Statistics event_wcstats -
Statistics event_wlstats -

Usage

Use this element to know the highest DML activity actual rows returned reached on a member for a service class, workload, or work class in the time interval collected.

rows_selected - Rows Selected monitor element

This is the number of rows that have been selected and returned to the application.

Table 127. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Database dbase_remote Basic
Application appl Basic
Application appl_remote Basic
For snapshot monitoring, this counter can be reset.
Table 128. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Connection event_conn Always collected
Usage
You can use this element to gain insight into the current level of activity within the database.

This element does not include a count of rows read for actions such as COUNT(*) or joins.

For a federated system;, you can compute the average time to return a row to the federated server from the data source: 
   average time = rows returned / aggregate query response time
You can use these results to modify CPU speed or communication speed parameters in SYSCAT.SERVERS. Modifying these parameters can impact whether the optimizer does or does not send requests to the data source.
Note: This element is collected at the dcs_dbase and dcs_appl snapshot monitor logical data groups if the gateway being monitored is at Db2 database version 7.2 or lower.

rows_updated - Rows updated monitor element

This is the number of row updates attempted.

Table 129. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated execution metrics for routines REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 130. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Database dbase_remote Basic
Application appl Basic
Application appl_remote Basic
For snapshot monitoring, this counter can be reset.
Table 131. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Connection event_conn Always collected
Database event_db Always collected
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmmetrics REQUEST METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE
Usage
You can use this element to gain insight into the current level of activity within the database.

This value does not include updates counted in the int_rows_updated monitor element. However, rows that are updated by more than one update statement are counted for each update.

rows_written - Rows Written monitor element

This is the number of rows changed (inserted, deleted or updated) in the table.

Table 132. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table table Basic
Application appl Basic
Application stmt Basic
Application subsection Statement
Dynamic SQL dynsql Statement
For snapshot monitoring, this counter can be reset.
Table 133. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Connection event_conn Always collected
Tables event_table Always collected
Statements event_stmt Always collected
Transactions event_xact Always collected
Usage
A high value for table-level information indicates there is heavy usage of the table and you may want to use the Run Statistics (RUNSTATS) utility to maintain efficiency of the packages used for this table.

For application-connections, statements, and dynsql logical data groupings, this element includes the number of rows inserted, updated, and deleted in temporary tables. It is possible in certain circumstances for its value to be greater than the sum of the monitor elements rows_inserted, rows_updated, and rows_deleted.

At the application, transaction, and statement levels, this element can be useful for analyzing the relative activity levels, and for identifying candidates for tuning.

rqsts_completed_total - Total requests completed monitor element

The total number of requests executed, including both application and internal requests. For service subclasses, this monitor element is only updated where the request completes. If the request moved between different service subclasses, it is not counted twice.

Table 134. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics REQUEST METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
Table 135. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_superclassstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE
Unit of work Reported in the system_metrics document. REQUEST METRICS BASE

rts_rows_modified - Rows modified since last real time statistics monitor element

Returns the number of rows modified since last real-time statistics collection.

Table 136. Table function monitoring information
Table function Monitor element collection level
ADMIN_GET_TAB_INFO table function - retrieve table size and state information Always collected
MON_GET_TABLE table function - get table metrics Always collected

Usage

Use this element and the stats_rows_modified monitor element to help determine if a running of the RUNSTATS command is required.

After a TRUNCATE TABLE statement is run, this element displays the value -1 until a RUNSTATS command is run against the table.