Deprecated SQL administrative routines and views

Expanded support is provided for the existing administrative routines and views by replacing them with new, more comprehensive routines or views.

Starting with version 10.1, routines with version-suffixed names are deprecated. The names of the routines do not have a version suffix so that the names remain consistent across releases. The replacement routines without a version-suffix might include modifications such as: columns added or removed, new data types for existing columns, or new values for existing columns. Use good practices when issuing queries on SQL administrative routines to minimize the impact from changes to these routines.

The following table provides a list of all the SQL administrative routines or views that are currently deprecated:
Table 1. Deprecated SQL administrative routines or views and their replacement routines or views
Deprecated routine or view Deprecated since New routine or view Replacement available since
GET_ROUTINE_SAR procedure version 11.1 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, fenced mode processes, and system entities for the database  
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 database registry settings in use version 10.1 ENV_GET_REG_VARIABLES table function - Retrieve database registry settings that are 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, fenced mode processes, and system entities for the database 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 and DBM_GET_CFG table function - 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  

The health monitor has been deprecated. The health monitor routines are also deprecated and might be removed from future releases. A new suite of GUI tools for managing data and data-centric applications is available and can be used instead of the discontinued Control Center tools. For more information, see Database management and application development tools.

The following section is a list of the deprecated health monitor routines: