DB2 Version 10.1 for Linux, UNIX, and Windows

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 for DB2 Version 10.1
Deprecated routine or view	Deprecated since	New routine or view	Replacement available since
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 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 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		Version 10.1
AM_BASE_RPTS table function - Activity event monitor reports	Version 10.1		Version 10.1
AM_DROP_TASK procedure - Delete a monitoring task	Version 10.1		Version 10.1
AM_GET_LOCK_CHN_TB procedure - Retrieve application lock chain data in a tabular format	Version 10.1		Version 10.1
AM_GET_LOCK_CHNS procedure - Retrieve lock chain information for a specific application	Version 10.1		Version 10.1
AM_GET_LOCK_RPT procedure - Retrieve application lock details	Version 10.1		Version 10.1
AM_GET_RPT procedure - Retrieve activity monitor data	Version 10.1		Version 10.1
AM_SAVE_TASK procedure - Create or modify a monitoring task	Version 10.1		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	SNAP_GET_APPL_INFO table function	Version 10.1
SNAP_GET_APPL_V95 table function - Retrieve appl logical data group snapshot information	Version 10.1	SNAP_GET_APPL table function	Version 10.1
SNAP_GET_BP_V95 table function - Retrieve bufferpool logical group snapshot information	Version 10.1	SNAP_GET_BP table function	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	SNAP_GET_DB table function	Version 10.1
SNAP_GET_DBM_V95 table function - Retrieve the dbm logical grouping snapshot information	Version 10.1	SNAP_GET_DBM table function	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
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	WLM_GET_SERVICE_CLASS_AGENTS 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	WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES 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 - Get complete activity details	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
SNAP_GET_STO_PATHS table function	Version 9.1	ADMIN_GET_STORAGE_PATHS table function - retrieve automatic storage path information	Version 10.1
SNAPSHOT_AGENT table function	Version 9.1	SNAP_GET_AGENT table function	Version 9.1
SNAPSHOT_APPL table function	Version 9.1	SNAP_GET_APPL table function	Version 10.1
SNAPSHOT_APPL_INFO table function	Version 9.1	SNAP_GET_APPL_INFO table function	Version 10.1
SNAPSHOT_BP table function	Version 9.1	SNAP_GET_BP table function	Version 10.1
SNAPSHOT_CONTAINER table function	Version 9.1	SNAP_GET_CONTAINER table function	Version 10.1
SNAPSHOT_DATABASE table function	Version 9.1	SNAP_GET_DB table function	Version 10.1
SNAPSHOT_DBM table function	Version 9.1	SNAP_GET_DBM table function	Version 10.1
SNAPSHOT_DYN_SQL table function	Version 9.1	SNAP_GET_DYN_SQL table function	Version 10.1
SNAPSHOT_FCM table function	Version 9.1	SNAP_GET_FCM table function	Version 9.1
SNAPSHOT_FCMNODE table function	Version 9.1	SNAP_GET_FCM_PART table function	Version 9.1
SNAPSHOT_FILEW procedure	Version 9.1	SNAP_WRITE_FILE procedure	Version 9.1
SNAPSHOT_LOCK table function	Version 9.1	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
SNAPSHOT_LOCKWAIT table function	Version 9.1	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
SNAPSHOT_QUIESCERS table function	Version 9.1	SNAP_GET_TBSP_QUIESCER table function	Version 9.1
SNAPSHOT_RANGES table function	Version 9.1	SNAP_GET_TBSP_RANGE table function	Version 9.1
SNAPSHOT_STATEMENT table function	Version 9.1	SNAP_GET_STMT table function	Version 9.1
SNAPSHOT_SUBSECT table function	Version 9.1	SNAP_GET_SUBSECTION table function	Version 9.1
SNAPSHOT_SWITCHES table function	Version 9.1	SNAP_GET_SWITCHES table function	Version 9.1
SNAPSHOT_TABLE table function	Version 9.1	SNAP_GET_TAB table function	Version 9.1
SNAPSHOT_TBREORG table function	Version 9.1	SNAP_GET_TAB_REORG table function	Version 9.1
SNAPSHOT_TBS table function	Version 9.1	SNAP_GET_TBSP table function	Version 9.1
SNAPSHOT_TBS_CFG table function	Version 9.1	SNAP_GET_TBSP_PART table function	Version 10.1
SQLCACHE_SNAPSHOT table function	Version 9.1	SNAP_GET_DYN_SQL table function	Version 10.1
SYSINSTALLROUTINES procedure	Version 9.1	Not available

The health monitor has been deprecated in DB2 for Linux, UNIX, and Windows Version 9.7 . The health monitor routines are also deprecated and might be removed in a future release. A new suite of GUI tools for managing DB2 for Linux, UNIX, and Windows 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: