A number of version-suffixed SQL administrative routines
have been deprecated in Version 10.1.
Start using the replacement routines before the deprecated routines
are removed in a future release.
Details
Starting with Version 10.1,
the names of administrative routines will not have a version suffix
to keep the names consistent across releases.
The deprecated
SQL administrative routines are as follows:
- ADMIN_GET_TAB_COMPRESS_INFO_V97
- ADMIN_GET_TAB_INFO_V97
- SNAP_GET_APPL_INFO_V95
- SNAP_GET_APPL_V95
- SNAP_GET_BP_V95
- SNAP_GET_CONTAINER_V91
- SNAP_GET_DBM_V95
- SNAP_GET_DB_V97
- SNAP_GET_DETAILLOG_V91
- SNAP_GET_DYN_SQL_V95
- SNAP_GET_STORAGE_PATHS_V97
- SNAP_GET_TAB_V91
- SNAP_GET_TBSP_PART_V97
- SNAP_GET_TBSP_V91
- WLM_GET_SERVICE_CLASS_AGENTS_V97
- WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES_V97
- WLM_GET_SERVICE_SUBCLASS_STATS_V97
- WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97
- WLM_GET_WORKLOAD_STATS_V97
Resolution
Modify your applications and
scripts to use the replacement routines or views.
Use good practices,
such as the following ones, when issuing queries on SQL administrative
routines:
- Use a list of columns rather than the wildcard character so that
the query will always return the same number of columns.
- Validate values returned
from a column to receive only expected values. For example, verify
that the value is within a range of valid values for that column.
DB2 Version 10.1 for Linux, UNIX, and Windows