DB2 Version 9.7 for Linux, UNIX, and Windows

Deprecated SQL administrative routines and their replacement routines or views

To provide expanded support in DB2® for Linux, UNIX, and Windows Version 9.7 for the existing administrative routines, some of the DB2 Version 9.5 routines have been replaced with new, more comprehensive routines or views.

Applications that use the DB2 for Linux, UNIX, and Windows Version 9.7 table functions should be modified to use the new functions or administrative views. The new table functions have the same base names as the original functions but are suffixed with '_Vxx' for the version of the product in which they were added (for example, _V97). In most cases, the new table functions and administrative views return additional information. The administrative views will always be based on the most current version of the table functions, and therefore allow for more application portability. As the columns may vary from one release to the next (that is, some are added and some are deleted), it is recommended that specific columns be selected from the administrative views, or that the result set be described if a SELECT * statement is used by an application.

Table 1. Deprecated SQL administrative routines or views and their replacement routines or views for DB2 Version 9.7 Fix Pack 1 or later fix packs
DB2 Version 9.7 deprecated function Deprecated since New Version 9.7 function or view in Fix Pack 1 or later fix packs
Version 9.7 Fix Pack 5
LOCKS_HELD administrative view - Retrieve information about the locks held Version 9.7 Fix Pack 1
LOCKWAITS administrative view - Retrieve current lockwaits information Version 9.7 Fix Pack 1
SNAPDB administrative view and SNAP_GET_DB_V95 table function - Retrieve snapshot information from the dbase logical group Version 9.7 Fix Pack 1
SNAPDB_MEMORY_POOL administrative view and SNAP_GET_DB_MEMORY_POOL table function - Retrieve database level memory usage 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 Fix Pack 5
SNAPLOCK administrative view and SNAP_GET_LOCK table function - Retrieve lock logical data group snapshot information Version 9.7 Fix Pack 1
SNAPLOCKWAIT administrative view and SNAP_GET_LOCKWAIT table function - Retrieve lockwait logical data group snapshot information Version 9.7 Fix Pack 1
Table 2. Deprecated SQL administrative routines and their replacement routines or views for DB2 Version 9.7
DB2 Version 9.5 deprecated function New Version 9.7 function or view
ADMINTABCOMPRESSINFO view and ADMIN_GET_TAB_COMPRESS_INFO table function - returns compressed information ADMINTABCOMPRESSINFO administrative view and ADMIN_GET_TAB_COMPRESS_INFO_V97 table function - returns compressed information
ADMIN_GET_TAB_INFO table function - Retrieve size and state information for tables ADMINTABINFO administrative view and ADMIN_GET_TAB_INFO_V97 table function - retrieve table size and state information
SNAPSTORAGE_PATHS administrative view and SNAP_GET_STORAGE_PATHS table function - Retrieve automatic storage path information SNAPSTORAGE_PATHS administrative view and SNAP_GET_STORAGE_PATHS_V97 table function - Retrieve automatic storage path information
SNAPTBSP_PART administrative view and SNAP_GET_TBSP_PART_V91 table function - Retrieve tablespace_nodeinfo logical data group snapshot information SNAPTBSP_PART administrative view and SNAP_GET_TBSP_PART_V97 table function - Retrieve tablespace_nodeinfo logical data group snapshot information
WLM_GET_ACTIVITY_DETAILS table function - Return detailed information about a specific activity MON_GET_ACTIVITY_DETAILS table function - Get complete activity details
WLM_GET_SERVICE_SUBCLASS_STATS table function - return statistics of service subclasses WLM_GET_SERVICE_SUBCLASS_STATS_V97 table function - Return statistics of service subclasses
WLM_GET_WORKLOAD_STATS table function - return workload statistics WLM_GET_WORKLOAD_STATS_V97 table function - Return workload statistics
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97 table function - return a list of activities
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES table function - List of workload occurrences WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES_V97 table function - list workload occurrences
WLM_GET_SERVICE_CLASS_AGENTS table function - List agents running in a service class WLM_GET_SERVICE_CLASS_AGENTS_V97 table function - list agents running in a service class

The health monitor has been deprecated in DB2 for Linux, UNIX, and Windows Version 9.7 . The deprecated health monitor interfaces are still supported in Version 9.7. 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 Control Center tools. For more information, see Database management and application development tools.

In the previous release, DB2 Version 9.5, there were also new functions that replaced DB2 Version 9.1 functions.