DB2 Version 9.7 for Linux, UNIX, and Windows

member - Database member monitor element

The numeric identifier for the database member from which the data was retrieved for this result record.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
ENV_GET_DB2_SYSTEM_RESOURCES table function - Return DB2® system information	Always collected
ENV_GET_SYSTEM_RESOURCES table function - Return system information	Always collected
ENV_GET_NETWORK_RESOURCES table function - Return network information	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details	Always collected
MON_GET_BUFFERPOOL table function - Get buffer pool metrics	Always collected
MON_GET_CONNECTION table function - Get connection metrics	Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics	Always collected
MON_GET_CONTAINER table function - Get table space container metrics	Always collected
MON_GET_EXTENT_MOVEMENT_STATUS - Get extent movement progress status metrics	Always collected
MON_GET_FCM - Get FCM metrics	Always collected
MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections	Always collected
MON_GET_INDEX table function - Get index metrics	Always collected
MON_GET_LOCKS table function - list all locks in the currently connected database
MON_GET_MEMORY_POOL table function - Get memory pool information	Always collected
MON_GET_MEMORY_SET table function - Get memory set information	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 table function - get detailed metrics for package cache entries	Always collected
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics	Always collected
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics	Always collected
MON_GET_TABLE table function - Get table metrics	Always collected
MON_GET_TABLESPACE table function - Get table space metrics	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics	Always collected
MON_GET_WORKLOAD table function - Get workload metrics	Always collected
MON_GET_WORKLOAuD_DETAILS table function - Get detailed workload metrics	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	-	ACTIVITY METRICS BASE
Statistics	-	REQUEST METRICS BASE
Statistics	-	REQUEST METRICS BASE
Unit of work	-	REQUEST METRICS BASE
Package cache	-	COLLECT BASE DATA
Locking	-	-

Usage

A DB2 member is a database manager instance that runs DB2 server software on a single host. A DB2 member accepts and processes database requests from applications connected to it.