GET_ROUTINE_SAR procedure |
|
Not available |
|
APPL_PERFORMANCE administrative view - Retrieve percentage of rows selected for an application |
Version 10.5 |
MON_CONNECTION_SUMMARY - Retrieve metrics for all connections |
|
APPLICATIONS administrative view - Retrieve connected database application information |
Version 10.5 |
MON_GET_CONNECTION table function - Get connection metrics |
|
BP_HITRATIO administrative view - Retrieve bufferpool hit ratio information |
Version 10.5 |
MON_BP_UTILIZATION administrative view - Retrieve metrics for bufferpools |
|
BP_READ_IO administrative view - Retrieve bufferpool read performance information |
Version 10.5 |
MON_BP_UTILIZATION administrative view - Retrieve metrics for bufferpools |
|
BP_WRITE_IO administrative view - Retrieve bufferpool write performance information |
Version 10.5 |
MON_BP_UTILIZATION administrative view - Retrieve metrics for bufferpools |
|
CONTAINER_UTILIZATION administrative view - Retrieve table space container and utilization information |
Version 10.5 |
MON_GET_CONTAINER table function - Get table space container metrics |
|
LOG_UTILIZATION administrative view - Retrieve log utilization information |
Version 10.5 |
MON_TRANSACTION_LOG_UTILIZATION administrative view - Retrieve log utilization information |
Version 10.5 |
LONG_RUNNING_SQL administrative view |
Version 10.5 |
MON_CURRENT_SQL - Retrieve key metrics for all activities on all members |
|
SNAP_WRITE_FILE procedure |
Version 10.5 |
Not available |
|
SNAPAGENT administrative view and SNAP_GET_AGENT table function - Retrieve agent logical data group application snapshot information |
Version 10.5 |
MON_GET_CONNECTION table function - Get connection metrics and MON_GET_AGENT table function - List agents running in a service class |
|
SNAPAPPL administrative view and SNAP_GET_APPL table function - Retrieve appl logical data group snapshot information |
Version 10.5 |
MON_GET_CONNECTION table function - Get connection metrics |
|
SNAPAPPL_INFO administrative view and SNAP_GET_APPL_INFO table function - Retrieve appl_info logical data group snapshot information |
Version 10.5 |
MON_GET_CONNECTION table function - Get connection metrics |
|
SNAPBP administrative view and SNAP_GET_BP table function - Retrieve bufferpool logical group snapshot information |
Version 10.5 |
MON_GET_BUFFERPOOL table function - Get buffer pool metrics |
|
SNAPBP_PART administrative view and SNAP_GET_BP_PART table function - Retrieve bufferpool_nodeinfo logical data group snapshot information |
Version 10.5 |
MON_GET_BUFFERPOOL table function - Get buffer pool metrics |
|
SNAPCONTAINER administrative view and SNAP_GET_CONTAINER table function - Retrieve tablespace_container logical data group snapshot information |
Version 10.5 |
MON_GET_CONTAINER table function - Get table space container metrics |
|
SNAPDB administrative view and SNAP_GET_DB table function - Retrieve snapshot information from the dbase logical group |
Version 10.5 |
MON_GET_DATABASE table function - Get database metrics |
Version 10.5 |
SNAPDBM administrative view and SNAP_GET_DBM table function - Retrieve the dbm logical grouping snapshot information |
Version 10.5 |
MON_GET_INSTANCE table function - Get instance level information |
Version 10.5 |
SNAPFCM administrative view and SNAP_GET_FCM table function - Retrieve the fcm logical data group snapshot information |
Version 10.5 |
MON_GET_FCM - Get FCM metrics |
|
SNAPDETAILLOG administrative view and SNAP_GET_DETAILLOG table function - Retrieve snapshot information from the detail_log logical data group |
Version 10.5 |
MON_GET_TRANSACTION_LOG table function - Get log information |
Version 10.5 |
SNAPFCM_PART administrative view and SNAP_GET_FCM_PART table function - Retrieve the fcm_node logical data group snapshot information |
Version 10.5 |
MON_GET_FCM - Get FCM metrics |
|
SNAPSTMT administrative view and SNAP_GET_STMT table function - Retrieve statement snapshot information |
Version 10.5 |
MON_CURRENT_SQL - Retrieve key metrics for all activities on all members and MON_GET_CONNECTION table function - Get connection metrics |
Version 9.7 |
SNAPTBSP administrative view and SNAP_GET_TBSP table function - Retrieve table space logical data group snapshot information |
Version 10.5 |
MON_GET_TABLESPACE table function - Get table space metrics |
|
SNAPTBSP_PART administrative view and SNAP_GET_TBSP_PART table function - Retrieve tablespace_nodeinfo logical data group snapshot information |
Version 10.5 |
MON_GET_TABLESPACE table function - Get table space metrics |
|
SNAPTBSP_QUIESCER administrative view and SNAP_GET_TBSP_QUIESCER table function - Retrieve quiescer table space snapshot information |
Version 10.5 |
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces |
Version 10.5 Fix
Pack 3 |
SNAPTBSP_RANGE administrative view and SNAP_GET_TBSP_RANGE table function - Retrieve range snapshot information |
Version 10.5 |
MON_GET_TABLESPACE_RANGE table function - Get information about table space ranges |
Version 10.5 Fix
Pack 3 |
SNAPUTIL administrative view and SNAP_GET_UTIL table function - Retrieve utility_info logical data group snapshot information |
Version 10.5 |
MON_GET_UTILITY table function - Get utilities running on the database |
Version 10.5 |
TBSP_UTILIZATION administrative view - Retrieve table space configuration and utilization information |
Version 10.5 |
MON_TBSP_UTILIZATION - Retrieve monitoring metrics for all table spaces and all database partitions |
|
ADMIN_GET_DBP_MEM_USAGE table function - Get total memory consumption for instance |
Version 10.1 |
ADMIN_GET_MEM_USAGE table function - Get total memory consumption for instance |
Version 10.1 |
ADMINTABCOMPRESSINFO administrative view and ADMIN_GET_TAB_COMPRESS_INFO table function (deprecated) - returns compressed information |
Version 10.1 |
ADMIN_GET_TAB_COMPRESS_INFO table function - estimate compression savings and ADMIN_GET_TAB_DICTIONARY_INFO table function - report properties of existing table dictionaries |
Version 10.1 |
ADMIN_GET_TAB_COMPRESS_INFO_V97 table function - Returns compressed information |
Version 10.1 |
ADMIN_GET_TAB_COMPRESS_INFO table function - estimate compression savings and ADMIN_GET_TAB_DICTIONARY_INFO table function - report properties of existing table dictionaries |
Version 10.1 |
ADMIN_GET_TAB_INFO_V95 table function - Retrieve size and state information for tables |
Version 10.1 |
ADMIN_GET_TAB_INFO table function |
Version 10.1 |
ADMIN_GET_TAB_INFO_V97 table function - Retrieve size and state information for tables |
Version 10.1 |
ADMIN_GET_TAB_INFO table function |
Version 10.1 |
AM_BASE_RPT_RECOMS table function - Recommendations for activity reports |
Version 10.1 |
Not available |
Version 10.1 |
AM_BASE_RPTS table function - Activity event monitor reports |
Version 10.1 |
Not available |
Version 10.1 |
AM_DROP_TASK procedure - Delete a monitoring task |
Version 10.1 |
Not available |
Version 10.1 |
AM_GET_LOCK_CHN_TB procedure - Retrieve application lock chain data in a tabular format |
Version 10.1 |
Not available |
Version 10.1 |
AM_GET_LOCK_CHNS procedure - Retrieve lock chain information for a specific application |
Version 10.1 |
Not available |
Version 10.1 |
AM_GET_LOCK_RPT procedure - Retrieve application lock details |
Version 10.1 |
Not available |
Version 10.1 |
AM_GET_RPT procedure - Retrieve activity monitor data |
Version 10.1 |
Not available |
Version 10.1 |
AM_SAVE_TASK procedure - Create or modify a monitoring task |
Version 10.1 |
Not available |
Version 10.1 |
APPLICATION_ID scalar function |
Version 10.1 |
MON_GET_APPLICATION_ID scalar function - Get connection application ID |
Version 10.1 |
REG_VARIABLES administrative view - Retrieve DB2 registry settings in use |
Version 10.1 |
ENV_GET_REG_VARIABLES table function - Retrieve DB2 registry settings in use |
Version 10.1 |
SNAPAGENT_MEMORY_POOL administrative view and SNAP_GET_AGENT_MEMORY_POOL table function - Retrieve memory_pool logical data group snapshot information |
Version 10.1 |
MON_GET_MEMORY_POOL table function - get memory pool information and MON_GET_MEMORY_SET table function - get memory set information |
Version 10.1 |
SNAP_GET_APPL_INFO_V95 table function - Retrieve appl_info logical data group snapshot information |
Version 10.1 |
MON_GET_CONNECTION table function - Get connection metrics |
Version 10.1 |
SNAP_GET_APPL_V95 table function - Retrieve appl logical data group snapshot information |
Version 10.1 |
MON_GET_CONNECTION table function - Get connection metrics |
Version 10.1 |
SNAP_GET_BP_V95 table function - Retrieve bufferpool logical group snapshot information |
Version 10.1 |
MON_GET_BUFFERPOOL table function - Get buffer pool metrics |
Version 10.1 |
SNAP_GET_CONTAINER_V91 table function - Retrieve tablespace_container logical data group snapshot information |
Version 10.1 |
MON_GET_CONTAINER table function - Get table space container metrics |
Version 10.1 |
SNAP_GET_DB_V97 table function - Retrieve snapshot information from the dbase logical group |
Version 10.1 |
MON_GET_DATABASE table function - Get database metrics |
Version 10.1 |
SNAP_GET_DBM_V95 table function - Retrieve the dbm logical grouping snapshot information |
Version 10.1 |
MON_GET_INSTANCE table function - Get instance level information |
Version 10.1 |
SNAP_GET_DETAILLOG_V91 table function - Retrieve snapshot information from the detail_log logical data group |
Version 10.1 |
MON_GET_TRANSACTION_LOG
table function |
Version 10.1 |
SNAP_GET_DYN_SQL_V95 table function - Retrieve dynsql logical group snapshot information |
Version 10.1 |
SNAP_GET_DYN_SQL table function |
Version 10.1 |
SNAPSTORAGE_PATHS administrative view and SNAP_GET_STORAGE_PATHS_V97 table function - Retrieve automatic storage path information |
Version 10.1 |
ADMIN_GET_STORAGE_PATHS table function - retrieve automatic storage path information |
Version 10.1 |
SNAPTAB administrative view and SNAP_GET_TAB table function - Retrieve table logical data group snapshot information |
Version 10.1 |
MON_GET_BUFFERPOOL table function - Get buffer pool metrics, MON_GET_TABLE table function - get table metrics, MON_GET_TABLESPACE table function - Get table space metrics,
and MON_BP_UTILIZATION administrative view - Retrieve metrics for bufferpools |
Version 10.1 |
SNAP_GET_TAB_V91 table function |
Version 10.1 |
MON_GET_TABLE table function - get table metrics |
Version 10.1 |
SNAP_GET_TBSP_PART_V97 table function - Retrieve tablespace_nodeinfo logical data group snapshot information |
Version 10.1 |
MON_GET_TABLESPACE table function - Get table space metrics |
Version 10.1 |
SNAP_GET_TBSP_V91 table function |
Version 10.1 |
MON_GET_TABLESPACE table function - Get table space metrics |
Version 10.1 |
SNAPHADR administrative view and SNAP_GET_HADR table function - Retrieve hadr logical data group snapshot information |
Version 10.1 |
MON_GET_HADR table function - Returns high availability disaster recovery (HADR) monitoring information |
Version 10.1 |
WLM_GET_SERVICE_CLASS_AGENTS_V97 table function - List agents running in a service class |
Version 10.1 |
MON_GET_AGENT table function - List agents running in a service class |
Version 10.1 |
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES_V97 table function - List of workload occurrences |
Version 10.1 |
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES table function - list workload occurrences |
Version 10.1 |
WLM_GET_SERVICE_SUBCLASS_STATS_V97 table function - return statistics of service subclasses |
Version 10.1 |
WLM_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses |
Version 10.1 |
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97 table function - Return a list of activities |
Version 10.1 |
MON_GET_ACTIVITY table function - Return a list of activities |
Version 10.1 |
WLM_GET_WORKLOAD_STATS_V97 table function - return workload statistics |
Version 10.1 |
WLM_GET_WORKLOAD_STATS table function - Return workload statistics |
Version 10.1 |
DB_PARTITIONS table function |
Version 9.8 |
DB2_MEMBER and DB2_CF administrative views and DB2_GET_INSTANCE_INFO table function |
Version 9.8 |
SNAPDB_MEMORY_POOL administrative view and SNAP_GET_DB_MEMORY_POOL table function - Retrieve database level memory usage information |
Version 9.7 |
MON_GET_MEMORY_SET table function - get memory set information
MON_GET_MEMORY_POOL table function - get memory pool information
|
Version 9.7 Fix Pack 5 |
SNAPDBM_MEMORY_POOL administrative view and SNAP_GET_DBM_MEMORY_POOL table function - Retrieve database manager level memory usage information |
Version 9.7 |
MON_GET_MEMORY_SET table function - get memory set information
MON_GET_MEMORY_POOL table function - get memory pool information
|
Version 9.7 Fix Pack 5 |
LOCKS_HELD administrative view - Retrieve information about locks held |
Version 9.7 |
MON_GET_APPL_LOCKWAIT table function - Get information about locks for which an application is waiting |
Version 9.7 Fix
Pack 1 |
MON_GET_LOCKS table function - List all locks in the currently connected database |
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details |
MON_LOCKWAITS administrative view - Retrieve metrics for applications that are waiting to obtain locks |
LOCKWAITS administrative view - Retrieve current lockwaits information |
Version 9.7 |
MON_GET_APPL_LOCKWAIT table function - Get information about locks for which an application is waiting |
Version 9.7 Fix
Pack 1 |
MON_GET_LOCKS table function - List all locks in the currently connected database |
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details |
MON_LOCKWAITS administrative view - Retrieve metrics for applications that are waiting to obtain locks |
SNAPLOCK administrative view and SNAP_GET_LOCK table function - Retrieve lock logical data group snapshot information |
Version 9.7 |
MON_GET_APPL_LOCKWAIT table function - Get information about locks for which an application is waiting |
Version 9.7 Fix
Pack 1 |
MON_GET_LOCKS table function - List all locks in the currently connected database |
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details |
MON_LOCKWAITS administrative view - Retrieve metrics for applications that are waiting to obtain locks |
SNAPLOCKWAIT administrative view and SNAP_GET_LOCKWAIT table function - Retrieve lockwait logical data group snapshot information |
Version 9.7 |
MON_GET_APPL_LOCKWAIT table function - Get information about locks for which an application is waiting |
Version 9.7 Fix
Pack 1 |
MON_GET_LOCKS table function - List all locks in the currently connected database |
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details |
MON_LOCKWAITS administrative view - Retrieve metrics for applications that are waiting to obtain locks |
WLM_GET_ACTIVITY_DETAILS table function - Return detailed information about a specific activity |
Version 9.5 |
MON_GET_ACTIVITY_DETAILS table function - Return information about an activity as an XML document |
Version 9.7 |
GET_DB_CONFIG procedure |
Version 9.1 |
DBCFG administrative view and DB_GET_CFG table function - Retrieve database configuration parameter information |
Version 9.1 |
GET_DBM_CONFIG table function |
Version 9.1 |
DBMCFG administrative view - Retrieve database manager configuration parameter information |
Version 9.1 |
GET_ROUTINE_SAR
procedure |
Version 9.1 |
CREATE PROCEDURE statement |
Version 9.1 |
PUT_ROUTINE_SAR procedure |
Version 9.1 |
CREATE PROCEDURE statement |
Version 9.1 |
SNAP_GET_STO_PATHS table function |
Version 9.1 |
ADMIN_GET_STORAGE_PATHS table function - retrieve automatic storage path information |
Version 10.1 |
SYSINSTALLROUTINES procedure |
Version 9.1 |
Not available |
|