nesting_level - Nesting level monitor element

This element shows the level of nesting or recursion in effect when the statement was being run; each level of nesting corresponds to nested or recursive invocation of a stored procedure or user-defined function (UDF). This monitor element is an alias for the nesting_level element.

The nesting_level monitor element is an alias of the stmt_nest_level monitor element.

Table 1. 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 DETAILS XML document) Always collected
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - Always collected
Deadlocks with Details History Values1 event_stmt_history Always collected
Deadlocks with Details History1 event_stmt_history Always collected
Activities event_activitystmt Always collected
Unit of work Reported in the package list. 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

You can use this element, along with stmt_invocation_id monitor element, to uniquely identify the invocation in which a particular SQL statement has been executed. You can also use this element in conjunction with other statement history entries to see the sequence of SQL statements that caused the deadlock.

network_interface_bound - Network interface hostname or IP address for remote client and server communications monitor element

The hostname or IP address corresponding to one or more network interfaces for communications between the member and remote clients and servers. The value is stored in the Db2® instance configuration file nicbinding.cfg. This value is NULL if no network interface is specified for the member in the configuration file.

Table 3. Table function monitoring information
Table function Monitor element collection level
   
MON_GET_INSTANCE table function - Get instance level information Always collected

network_time_bottom - Minimum Network Time for Statement monitor element

This element represents the shortest network time for a statement executed against this DCS database or in this DCS application, or having used this many data transmissions. (Network time is the difference between host response time and elapsed execution time for a statement.)

Element identifier
network_time_bottom
Element type
watermark
Table 4. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement, Timestamp
DCS Application dcs_appl Statement, Timestamp
Data Transmission stmt_transmissions Statement, Timestamp
For snapshot monitoring, this counter can be reset.

Usage

Use this element to get a better idea of the database activity and network traffic at the database or application levels.

This element is composed of two subelements that report time spent as seconds and microseconds (one millionth of a second). The names of the subelements can be derived by adding "_s" and "_ms" to the name of this monitor element. To retrieve the total time spent for this monitor element, the values of the two subelements must be added together. For example, if the "_s" subelement value is 3 and the "_ms" subelement value is 20, then the total time spent for the monitor element is 3.00002 seconds.

network_time_top - Maximum Network Time for Statement monitor element

This element represents the longest network time for a statement executed against this DCS database or in this DCS application, or having used this many data transmissions. (Network time is the difference between host response time and elapsed execution time for a statement.)

Element identifier
network_time_top
Element type
watermark
Table 5. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement, Timestamp
DCS Application dcs_appl Statement, Timestamp
Data Transmission stmt_transmissions Statement, Timestamp
For snapshot monitoring, this counter can be reset.

Usage

Use this element to get a better idea of the database activity and network traffic at the database or application levels. Note that this element is not collected when the timestamp switch is off.

This element is composed of two subelements that report time spent as seconds and microseconds (one millionth of a second). The names of the subelements can be derived by adding "_s" and "_ms" to the name of this monitor element. To retrieve the total time spent for this monitor element, the values of the two subelements must be added together. For example, if the "_s" subelement value is 3 and the "_ms" subelement value is 20, then the total time spent for the monitor element is 3.00002 seconds.

no_change_updates - Number of no change row updates monitor element

The number of row updates that resulted in no changes to any of the column values of a row. If a LOB, XML, or LONG column is included in the SET clause of an UPDATE statement, every row affected by that statement is assumed to change, and will not participate in this counter. For column-organized tables, this counter is always 0.
Table 8. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TABLE table function - get table metrics Always collected

node_number - Node Number monitor element

The number assigned to the node in the db2nodes.cfg file.

Table 9. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager collected Basic
Database Manager memory_pool Basic
Database Manager fcm Basic
Database Manager fcm_node Basic
Database Manager utility_info Basic
Database detail_log Basic
Buffer Pool bufferpool_nodeinfo Buffer Pool
Table Space rollforward Basic
Lock lock Basic
Lock lock_wait Basic
Database db_sto_path_info Buffer Pool
Table 10. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Connections event_connheader Always collected
Deadlocks lock Always collected
Overflow Record event_overflow Always collected
Database event_dbmemuse Always collected
Connection event_connmemuse Always collected
Usage
This value identifies the current node number, which can be used when monitoring multiple nodes.

nonboundary_leaf_node_splits - Non-boundary leaf node splits monitor element

A non-boundary leaf node split is when a leaf node split is triggered by the insertion of a key that is not a new highest or new lowest key in an index. The nonboundary_leaf_node_splits monitor element returns the number of times a non-boundary leaf node was split during an insert operation.

Table 11. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INDEX table function - Get index metrics Always collected

num_agents - Number of Agents Working on a Statement monitor element

Number of concurrent agents currently executing a statement or subsection.

Table 12. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_ACTIVITY table function - Return a list of activities Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always collected
Table 13. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application stmt Statement
Application subsection Statement
Usage
An indicator how well the query is parallelized. This is useful for tracking the progress of query execution, by taking successive snapshots.

num_assoc_agents - Number of Associated Agents monitor element

At the application level, this is the number of subagents associated with an application. At the database level, it is the number of subagents for all applications.

Table 15. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Application appl_info Basic
Usage
You can use this element to help evaluate your settings for your agent configuration parameters.

num_columns_referenced - Number of columns referenced monitor element

This element counts the number of columns referenced during the execution of a section for an SQL statement.

Table 16. Table function monitoring information
Table function Monitor element collection level
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED

Usage

The following statement would increase this element by 2, regardless of the number of row read by the query:
SELECT C1, C2 FROM T1
This element applies to both column-organized and row-organized tables. Columns referenced in synopsis tables and temporary tables are not included in this counter.

num_compilations - Statement Compilations monitor element

The number of different compilations for a specific SQL statement.

Table 17. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Dynamic SQL dynsql Basic
Usage
Some SQL statements issued on different schemas, such as SELECT t1 FROM test, will appear to be the same statement in the database cache even though they refer to different access plans. Use this value in conjunction with num_executions to determine whether a bad compilation environment is skewing the results of dynamic SQL snapshot statistics.

num_coord_exec - Number of executions by coordinator agent monitor element

The number of times this section was executed by a coordinator agent.

Table 20. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - Always collected

num_coord_exec_with_metrics - Number of executions by coordinator agent with metrics monitor element

The number of times this section was executed by a coordinator agent and monitoring metrics were being captured

Table 22. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - Always collected

num_db_storage_paths - Number of automatic storage paths monitor element

The number of automatic storage paths associated with a database.

Table 23. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Usage note
You can use this element with the db_storage_path monitor element to identify the storage paths that are associated with this database.
If you use storage groups, this element shows the number of automatic storage paths in the default database storage group only.

num_exec_with_metrics - Number of executions with metrics collected monitor element

The number of times that this SQL statement section has been executed with the metrics collected. This element can be used to calculate the per execution value for monitor elements for statements in the package cache.

Table 25. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - Always collected

num_executions - Statement executions monitor element

The number of times that an SQL statement has been executed.

Table 27. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Dynamic SQL dynsql Basic
For snapshot monitoring, this counter can be reset.
Table 28. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - Always collected

Usage

You can use this element to identify the most frequently executed SQL statements in your system.

At the package cache level, use this element to compute averages for the activity metrics reported per statement. For example, the average CPU usage for an execution of a statement reported at the package cache level can be calculated by the following formula:
total_cpu_time / num_exec_with_metrics

Use the num_exec_with_metrics monitor element instead of the num_executions monitor element when computing averages, since the num_executions monitor element counts all executions of a statement, regardless of whether or not the execution of the statement contributed to the activity metrics that are reported.

NUM_EXEC_WITH_ERROR - The number of executions with errors monitor element

The number of executions of this statement that resulted in an error.

Table 29. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get package cache statement metrics Always collected
Table 30. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache event_pkgcache Always collected

NUM_EXEC_WITH_WARNING - The number of executions with warnings monitor element

The number of executions of this statement that resulted in a warning.

Table 31. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get package cache statement metrics Always collected
Table 32. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache event_pkgcache Always collected

num_gw_conn_switches - Connection Switches monitor element

The number of times that an agent from the agents pool was primed with a connection and was reassigned for use with a different DRDA database.

Table 35. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information Always collected
Table 36. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic

Usage

For most users, the default setting of the num_poolagents configuration parameter ensures optimal performance. The default setting for this configuration parameter automatically manages agent pooling and avoids reassigning agents.

To reduce the value of this monitor element, adjust the value of the num_poolagents configuration parameter.

The GET SNAPSHOT command displays the num_gw_conn_switches monitor element as "Gateway connection pool agents stolen".

num_indoubt_trans - Number of Indoubt Transactions monitor element

The number of outstanding indoubt transactions in the database.

Table 37. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information ACTIVITY METRICS BASE
Table 38. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
Usage
Indoubt transactions hold log space for uncommitted transactions, which can cause the logs to become full. When the logs are full, further transactions cannot be completed. The resolution of this problem involves a manual process of heuristically resolving the indoubt transactions. This monitor element provides a count of the number of currently outstanding indoubt transactions that must be heuristically resolved.

num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element

The num_log_buffer_full element stores the number of times agents have to wait for log data to write to disk while copying log records into the log buffer. This value is incremented per agent per incident. For example, if two agents attempt to copy log data while the buffer is full, then this value is incremented by two.
Table 39. 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_TRANSACTION_LOG table function - Get log information Always collected
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 40. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 41. 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_scstats (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
Package cache Reported in the activity_metrics document. ACTIVITY METRICS BASE

Usage

Use this element to determine if the logbufsz database configuration parameter needs to be increased.

num_log_data_found_in_buffer - Number of Log Data Found In Buffer monitor element

The number of times an agent reads log data from the buffer. Reading log data from the buffer is preferable to reading from the disk because the latter is slower.

Table 42. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information Always collected
Table 43. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 44. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Usage
Use this element in conjunction with the num_log_read_io element to determine if the LOGBUFSZ database configuration parameter needs to be increased.

num_log_part_page_io - Number of Partial Log Page Writes monitor element

The number of I/O requests issued by the logger for writing partial log data to the disk.

Table 45. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information Always collected
Table 46. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 47. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Usage
Use this element in conjunction with the log_writes, log_write_time, and num_log_write_io elements to determine if the current disk is adequate for logging.

num_log_read_io - Number of Log Reads monitor element

The number of I/O requests issued by the logger for reading log data from the disk.

Table 48. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information Always collected
Table 49. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 50. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Usage
Use this element in conjunction with the log_reads and log_read_time elements to determine if the current disk is adequate for logging.

num_log_write_io - Number of Log Writes monitor element

The number of I/O requests issued by the logger for writing log data to the disk.

Table 51. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information Always collected
Table 52. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 53. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Usage
Use this element in conjunction with the log_writes and log_write_time elements to determine if the current disk is adequate for logging.

num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element

This monitor element reports the number of times the lock wait threshold (set using mon_lw_thresh configuration parameter) was exceeded and a lock wait event was captured by the locking event monitor. If no lock wait event is generated, the monitor element is not incremented.

Table 54. 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 55. 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
Package cache Reported in the activity_metrics document. ACTIVITY METRICS BASE

Unit of work

Reported in the system_metrics document.

REQUEST METRICS BASE

num_nodes_in_db2_instance - Number of Nodes in Partition monitor element

The number of nodes on the instance where the snapshot was taken.

Table 56. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
Table 57. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Event Log Header event_log_header Always collected
Usage
Use this element to determine the number of nodes for an instance. For non-partitioned system databases, this value will be 1.

num_page_dict_built - Number of page-level compression dictionaries created or recreated

The number of page-level compression dictionaries created or recreated for a table since the database was last activated.

Table 58. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TABLE table function - get table metrics Always collected

num_ref_with_metrics - Number of references with metrics monitor element

The total number of times that a section referenced the database object. The usage list for the data object must be created and active; in addition the collection of object metrics must be enabled for the section.

Table 60. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INDEX_USAGE_LIST table function - Returns information from an index usage list Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list Always collected

num_remaps - Number of remaps monitor element

Count of the number of times this activity has been remapped. If num_remaps is greater than zero, the service_class_id of this activity record is the ID of the last service class to which the activity was remapped.

Table 62. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity Always collected

Usage

Use this information to verify whether the activity was remapped the expected number of times.

num_routines - Number of routines monitor element

Number of procedures, external functions, compiled functions, and compiled triggers that might be invoked during section execution.

Table 64. Event Monitoring Information
Event Type Logical Data Grouping Monitor Element Collection Level
Activities event_activitystmt Always collected
Package Cache event_pkgcache Always collected

Usage

Use MON_GET_SECTION_ROUTINE table function to list the routines and triggers. This list can be compared to the output from the MON_GET_ROUTINE and MON_GET_ROUTINE_EXEC_LIST table functions.

num_tbsps - Number of table spaces monitor element

The number of table spaces associated with a logged event.

Table 65. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_UTILITY table function - Get utilities running on the database Always collected
Table 66. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change history utilstart Always collected

Usage

For the change history event monitor, if the object_type element is DATABASE or TABLESPACE, then this value is the number of table spaces.

num_threshold_violations - Number of threshold violations monitor element

The number of threshold violations that have taken place in this database since it was last activated. This monitor element is an alias of the thresh_violations - Number of threshold violations monitor element monitor element, which is returned by some monitoring (MON_*) table functions.
Table 67. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 68. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected

Usage

This element can be used to help determine whether or not thresholds are effective for this particular application or whether the threshold violations are excessive.

num_transmissions - Number of Transmissions monitor element

Number of data transmissions between the Db2 Connect gateway and the host that was used to process this DCS statement. (One data transmission consists of either one send or one receive.)

Note:

This is a legacy monitor element that is not relevant for Db2 UDB Version 8.1.2 or higher. If you are using Db2 UDB Version 8.1.2 or higher, refer to the num_transmissions_group monitor element.

Element identifier
num_transmissions
Element type
counter
-->
Table 69. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Statement dcs_stmt Statement
Usage
Use this element to get a better understanding of the reasons why a particular statement took longer to execute. For example, a query returning a large result set may need many data transmissions to complete.

num_transmissions_group - Number of Transmissions Group monitor element

The range of data transmissions between the Db2 Connect gateway and the host that was used to process this DCS statement. (One data transmission consists of either one send or one receive.)

Table 70. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Statement dcs_stmt Statement
Usage
Use this element to get a better understanding of the reasons why a particular statement took longer to execute. For example, a query returning a large result set may need many data transmissions to complete.
The constants representing the ranges of transmissions are described as follows and are defined in sqlmon.h.
API Constant Description
SQLM_DCS_TRANS_GROUP_2 2 transmissions
SQLM_DCS_TRANS_GROUP_3TO7 3 to 7 transmissions
SQLM_DCS_TRANS_GROUP_8TO15 8 to 15 transmissions
SQLM_DCS_TRANS_GROUP_16TO64 16 to 64 transmissions
SQLM_DCS_TRANS_GROUP_GT64 Greater than 64 transmissions

number_in_bin - Number in bin monitor element

This element holds the count of the number of activities or requests that fall within the histogram bin.

Table 71. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_histogrambin -

Usage

Use this element to represent the height of a bin in the histogram.