DB2 Version 10.1 for Linux, UNIX, and Windows

Some version-suffixed SQL administrative routines have been discontinued

A number of SQL administrative routines have been discontinued in Version 10.1. You should remove all references to these routines.

Details

In Version 9.1 and Version 9.5, some version-suffixed SQL administrative routines were deprecated. These routines have now been discontinued. The replacement routines in Version 10.1 have more comprehensive functionality.

The following table shows the routines that are now discontinued and their replacement routine:

Table 1. Discontinued SQL administrative routines and their replacement routines
Discontinued routine	Replacement routine
SNAP_GET_DB_V91	SNAP_GET_DB table function
SNAP_GET_DB_V95	SNAP_GET_DB table function
SNAP_GET_DYN_SQL_V91	SNAP_GET_DYN_SQL table function
SNAP_GET_TBSP_PART_V91	SNAP_GET_TBSP_PART table function

Note: If you call any of the discontinued routines, the SQL0440N error message is returned.

Resolution

Modify all your applications and scripts and remove all references to these routines or use the replacement routines or views indicated in "Deprecated SQL administrative routines and views".