N

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).

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_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	-	-
Deadlocks with Details History Values¹	event_stmt_history	-
Deadlocks with Details History¹	event_stmt_history	-
Activities	event_activitystmt	-
Unit of work	Reported in the package list.	-

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_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 3. 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 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. 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.

nleaf - Number of leaf pages monitor element

The approximate number of leaf pages.

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

nlevels - Number of index levels monitor element

Number of index levels. This is an approximation.

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

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.

Table 7. 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 8. 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 9. 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 10. 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.

Element identifier: num_agents
Element type: gauge

Table 11. 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.

Element identifier: num_assoc_agents
Element type: gauge

Table 12. 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_compilations - Statement Compilations monitor element

The number of different compilations for a specific SQL statement.

Table 13. 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 DB2® cache even though they refer to different access plans. Use this value in conjunction with num_executions to determine whether a bad compilation environment may be 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 14. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine	Always collected

Table 15. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Package cache	-	COLLECT BASE DATA

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 16. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine	Always collected

Table 17. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Package cache	-	COLLECT BASE DATA

num_db_storage_paths - Number of automatic storage paths monitor element

The number of automatic storage paths associated with a database.

Table 18. 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_executions - Statement executions monitor element

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

Table 19. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine	Always collected

Table 20. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Dynamic SQL	dynsql	Basic

For snapshot monitoring, this counter can be reset.

Table 21. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Package cache	-	COLLECT BASE DATA

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_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 22. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine	Always collected

Table 23. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Package cache	-	COLLECT BASE DATA

num_extents_left - Number of extents left to process monitor element

The number of extents left to move during this table rebalancing process.

Table 24. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_EXTENT_MOVEMENT_STATUS - Get extent movement progress status metrics	Always collected

num_extents_moved - Number of extents moved monitor element

The number of extents moved so far during this extent movement operation.

Table 25. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_EXTENT_MOVEMENT_STATUS - Get extent movement progress status metrics	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 26. 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 27. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information	ACTIVITY METRICS BASE

Table 28. 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 29. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_FORMAT_XML_METRICS_BY_ROW - Get formatted row-based output for all metrics	Not applicable; reports whichever elements are contained in the XML document provided as input to the formatting function.
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_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_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

Table 30. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 31. 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_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 32. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information	Always collected

Table 33. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 34. 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 35. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information	Always collected

Table 36. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 37. 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 38. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information	Always collected

Table 39. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 40. 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 41. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TRANSACTION_LOG table function - Get log information	Always collected

Table 42. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 43. 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 44. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_FORMAT_XML_METRICS_BY_ROW - Get formatted row-based output for all metrics	Not applicable; reports whichever elements are contained in the XML document provided as input to the formatting function.
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_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_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 45. 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_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 46. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database Manager	db2	Basic

Table 47. 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 48. 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 49. 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_references - Number of references monitor element

The number of times that this section has referenced this object since it was added to the list.

Table 50. 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 51. 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 52. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details	Always collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries	Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine	Always collected

Table 53. 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 referenced in the input section. You can use the MON_GET_ROUTINE and MON_GET_ROUTINE_EXEC_LIST table functions as part of a detailed investigation of the impact of these routines on the system.

num_tbsps - Number of table spaces monitor element

The number of table spaces associated with a logged event.

Table 54. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Change history	utilstart	Always collected

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 55. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 56. 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 57. 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 58. 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 59. 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.