Summary of deprecated and discontinued Db2 functionality in version 11.1 and earlier releases

Due to changes in related functionality, the introduction of new functionality, or the removal of support, some Db2 functionality that was available in earlier releases has been either deprecated or discontinued. Review this summary to understand the overall impact of these changes on your environment.
The functionality is grouped by the release in which the deprecation started. The information provided is cumulative: to get the complete list of deprecated functionality for a particular release, also review the information provided for the earlier releases:
Note:
  1. Pointers to supplemental information are provided if available.
  2. Information about deprecated functionality for add-on features such as Spatial Extender is not included.
  3. Information about deprecated registry variables related to functionality not described in other tables is listed separately.
To view the most up-to-date lists of discontinued functionality by Db2 database product release, use the following information:
Table 1. Discontinued functionality by Db2 database product release
Release Links to additional information
Version 9.7
version 10.1
version 10.5

Functionality deprecated in Version 9.5 or earlier releases

The following table shows the functionality that is deprecated in Version 9.5 and might be discontinued in version 10.1 or later releases. The Version 9.5 functionality that was discontinued in Version 9.7 is not shown because it is not present in databases for Version 9.7 or later releases.
Table 2. Functionality deprecated in Version 9.5 or earlier releases that is discontinued in version 10.1 or later releases
Functionality Discontinued in release Links to additional information
ADD PARTITIONING KEY and DROP PARTITIONING KEY clauses of the ALTER TABLE statement To be determined ADD PARTITIONING KEY clause of the ALTER TABLE statement is deprecated DROP PARTITIONING KEY clause of the ALTER TABLE statement is deprecated
COLNAMES column in SYSCAT.INDEXES To be determined COLNAMES column in SYSCAT.INDEXES is deprecated
Database logging using raw devices To be determined Database logging using raw devices is deprecated
Default function entry points support in external routine libraries To be determined External routines now require an explicit entry point specification
iCheckPending parameter To be determined Check pending table state is replaced and iCheckPending parameter is deprecated
IMPORT command options CREATE and REPLACE_CREATE To be determined IMPORT command options CREATE and REPLACE_CREATE are deprecated
logretain and userexit configuration parameter version 10.1 Some configuration parameters have been deprecated and discontinued
the -file option of the db2flsn command To be determined Log control file SQLOGCTL.LFH has been renamed and copied
LONG VARCHAR and LONG VARGRAPHIC data types To be determined FP1: LONG VARCHAR and LONG VARGRAPHIC data types have been deprecated
Network Information Services (NIS and NIS+) support and related registry variable (Linux® and UNIX operating systems) To be determined Network Information Services (NIS and NIS+) support is deprecated (Linux and UNIX)
agentpri configuration parameter To be determined Some database manager configuration parameters have changed
app_ctl_heap_sz, appgroup_mem_sz, and groupheap_ratio configuration parameters To be determined Some database configuration parameters have changed
buffpage database configuration parameter To be determined Version 8 incompatibilities with previous releases
indexsort database configuration parameter Version 8 Version 8 incompatibilities with previous releases
maxagents and maxcagents configuration parameters To be determined Some database manager configuration parameters have changed
numsegs database configuration parameter To be determined Some database configuration parameters have changed
query_heap_sz database manager configuration parameter To be determined Some database manager configuration parameters have changed
Static data stream snapshot output To be determined Static data stream snapshot output is deprecated
SNAP_GET_DB_V91, SNAP_GET_DB_V95, and SNAP_GET_DYN_SQL_V91 table functions version 10.1 Some version-suffixed SQL administrative routines have been discontinued
ADMINTABCOMPRESSINFO and SNAPTBSP_PART administrative views, ADMIN_GET_TAB_COMPRESS_INFO and WLM_GET_ACTIVITY_DETAILS table functions To be determined Deprecated Version 9.5 SQL administrative routines and their replacement routines or views
IBM® Db2 Geodetic Data Management Feature version 10.1 IBM Db2 Geodetic Data Management Feature has been discontinued
HP-UX 32-bit client support To be determined FP7: HP-UX 32-bit client support has been deprecated
Db2 Health Advisor To be determined FP8: Db2 Health Advisor has been deprecated
The following table shows the registry variables that are deprecated in Version 9.5 and might be discontinued in version 10.1 or later releases. The Version 9.5 registry variables that were discontinued in Version 9.7 is not shown because it is not present in databases for Version 9.7 or later releases.
Table 3. Registry variables deprecated in Version 9.5 and possibly discontinued in or a later release
Registry variable Discontinued in release Links to additional information
DB2_ALLOCATION_SIZE To be determined Some registry and environment variables are deprecated
DB2ATLD_PORTS To be determined Some registry and environment variables are deprecated
DB2_ASYNC_IO_MAXFILOP version 10.1 Some registry and environment variables are discontinued
DB2_BAR_AUTONOMIC_DISABLE version 10.1 Some registry and environment variables are discontinued
DB2BPVARS To be determined Some registry and environment variables are deprecated
DB2_COMMIT_ON_EXIT To be determined Deprecated registry variables in Version 9.1 table
DB2COUNTRY version 10.1 Some registry and environment variables are discontinued
DB2_CORRELATED_PREDICATES To be determined Deprecated registry variables in Version 9.1
DB2DEFPREP version 10.1 Some registry and environment variables are discontinued
DB2_DJ_COMM version 10.1 Some registry and environment variables are discontinued
DB2DMNBCKCTLR version 10.1 Some registry and environment variables are discontinued
DB2_ENABLE_BUFPD To be determined See the Deprecated registry variables in Version 9.1 table
DB2_ENABLE_SINGLE_NIS_GROUP To be determined Deprecated registry variables in Version 9.1
DB2FFDC version 10.1 Some registry and environment variables are discontinued
DB2_HASH_JOIN version 10.1 Some registry and environment variables are discontinued
DB2_INDEX_FREE version 10.5 Some registry and environment variables are discontinued
DB2_MAP_XML_AS_CLOB_FOR_DLC version 10.1 Some registry and environment variables are discontinued
DB2_MAPPED_BASE To be determined Deprecated registry variables in Version 9.1
DB2MEMMAXFREE version 10.1 Some registry and environment variables are discontinued
DB2_NO_MPFA_FOR_NEW_DB To be determined Deprecated registry variables in Version 9.1
DB2_PARTITIONEDLOAD_DEFAULT To be determined Some registry and environment variables are deprecated
DB2_PRED_FACTORIZE To be determined Deprecated registry variables in Version 9.1
DB2PRIORITIES and DB2NTPRICLASS To be determined Some registry and environment variables are deprecated
DB2ROUTINE_DEBUG version 10.1 Some registry and environment variables are discontinued
DB2_RR_TO_RS version 10.1 Some registry and environment variables are discontinued
DB2_SNAPSHOT_NOAUTH version 10.1 Some registry and environment variables are discontinued
DB2_TRUSTED_BINDIN version 10.5 Some registry and environment variables are discontinued
DB2_UPDATE_PART_KEY version 10.1 Some registry and environment variables are discontinued
DB2_VENDOR_INI To be determined Some registry and environment variables are discontinued
DB2YIELD version 10.1 Some registry and environment variables are discontinued

Functionality deprecated in Version 9.7

The following table shows the functionality that is deprecated in Version 9.7. If the functionality is discontinued, the table also shows the release where the functionality was discontinued.
Table 4. Functionality deprecated in Version 9.7
Functionality Discontinued in release Links to additional information
CREATE EVENT MONITOR FOR DEADLOCKS statement and DB2DETAILDEADLOCK event monitor To be determined CREATE EVENT MONITOR FOR DEADLOCKS statement and DB2DETAILDEADLOCK event monitor have been deprecated
CREATE EVENT MONITOR FOR TRANSACTIONS statement To be determined CREATE EVENT MONITOR FOR TRANSACTIONS statement has been deprecated
Db2 Governor To be determined Db2 Governor and Query Patroller have been deprecated
Query Patroller version 10.1 Query Patroller has been discontinued
IBM Db2 Geodetic Data Management Feature version 10.1 IBM Db2 Geodetic Data Management Feature has been discontinued
db2imigr and db2ckmig commands version 10.1 db2imigr and db2ckmig commands have been discontinued
MIGRATE DATABASE commands; sqlemgdb and sqlgmgdb APIs To be determined Instance and database migration commands and APIs have been deprecated
-s parameter of the db2iupdt command version 10.1 -s parameter of the db2iupdt command has been discontinued
-file parameter of the db2rfpen command version 10.1 -file parameter of the db2flsn and db2rfpen commands has been discontinued
-global parameter of the db2trc, db2pd, db2fodc, db2pdcfg, and db2support command To be determined FP4: The -global parameter for troubleshooting tools has been deprecated
CONVERT parameter of the REORG INDEXES command Version 9.7 Type-1 indexes have been discontinued
Worksheet Format (WSF) for Import and Export utilities version 10.1 Worksheet Format (WSF) for Import and Export utilities have been discontinued
LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands and related APIs:
  • sqlbctsq
  • sqlbftsq
  • sqlbftpq
  • sqlbgtss
  • sqlbmtsq
  • sqlbotsq
  • sqlbstpq
  • sqlbstsq
  • sqlbtcq
 To be determined LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands have been deprecated
MIGRATE_PRIOR_VERSIONS and the CONFIG_ONLY response file keywords To be determined Some response file keywords have been deprecated
DB2LOADQUERY_TYPE1_INDEXES and the DB2REORG_CONVERT values in certain Db2 API data structures Version 9.7 Type-1 indexes have been discontinued
sqlugrpn API To be determined sqlugrpn API has been deprecated
sqlugtpi API To be determined sqlugtpi API has been deprecated
db2HistoryCloseScan, db2HistoryGetEntry, db2HistoryOpenScan, and db2HistoryUpdate APIs version 10.1 Support in COBOL, FORTRAN, and REXX for Db2 APIs that manage database history records has been discontinued
details_xml reported in logical data groups To be determined FP6: Reporting of metrics in details_xml by the statistics event monitor has been deprecated
dyn_query_mgmt database configuration parameter version 10.1 Some configuration parameters have been deprecated and discontinued
DB2SE_USA_GEOCODER version 10.1 DB2SE_USA_GEOCODER has been discontinued
Subset of Net Search Extender features and commands To be determined Subset of Net Search Extender features and commands have been deprecated
Subset of SQL administrative routines To be determined Deprecated Version 9.7 SQL administrative routines and their replacement routines or views
SNAP_GET_TBSP_PART_V91 table function version 10.1 Some version-suffixed SQL administrative routines have been discontinued
SNAP_GET_DBM_MEMORY_POOL table function and SNAPDBM_MEMORY_POOL administrative view To be determined FP5: Some monitoring routines and views are deprecated
SNAP_GET_DB_MEMORY_POOL table function and SNAPDB_MEMORY_POOL administrative view To be determined FP5: Some monitoring routines and views are deprecated
SNAP_GET_AGENT_MEMORY_POOL table function and SNAPAGENT_MEMORY_POOL administrative view To be determined FP5: Some monitoring routines and views are deprecated
The following Db2 administration tools:
  • Activity Monitor
  • Command Editor
  • Configuration Assistant
  • Control Center and associated wizards and advisors
  • Control Center plug-in extensions
  • Event Analyzer
  • Health Center
  • Indoubt Transaction Monitor
  • Journal
  • License Center
  • Memory Visualizer
  • Query Patroller Center
  • Satellite Administration Center
  • Task Center
 version 10.1 Db2 administration tools have been discontinued
Db2 administration server (DAS) To be determined Control Center tools and Db2 administration server (DAS) have been deprecated
Db2 Health Advisor To be determined FP4: Db2 Health Advisor has been deprecated
Health monitor To be determined Health monitor has been deprecated
HP-UX 32-bit client support To be determined FP3: HP-UX 32-bit client support has been deprecated
IBM SDK Version 1.4.2 support for Java™ routines To be determined IBM Software Developer's Kit (SDK) 1.4.2 support for Java routines has been deprecated
Visual Studio 2005 support version 10.1 Visual Studio 2005 support has been discontinued
The following table shows the registry variables that are deprecated in Version 9.7. If the registry variables are discontinued, the table also shows the release where the registry variables were discontinued.
Table 5. Registry variables deprecated in Version 9.7
Registry variables Discontinued in release Links to additional information
DB2_CAPTURE_LOCKTIMEOUT To be determined Some registry and environment variables have been deprecated
DB2_QP_BYPASS_APPLICATIONS version 10.1 Some registry and environment variables are discontinued
DB2_QP_BYPASS_COST version 10.1 Some registry and environment variables are discontinued
DB2_QP_BYPASS_USERS version 10.1 Some registry and environment variables are discontinued
DB2_SERVER_ENCALG To be determined Some registry and environment variables have been deprecated
DB2_USE_DB2JCCT2_JROUTINE version 10.1 Some registry and environment variables have been deprecated
Query Patroller registry variables:
  • DQP_ABORTRESULT
  • DQP_CHILD_WAIT
  • DQP_DISKMON
  • DQP_EXIT_AN
  • DQP_INTERVAL
  • DQP_LAST_RESULT_DEST
  • DQP_LOCAL_SERVANTS
  • DQP_LOG
  • DQP_LOGMON
  • DQP_MAIL
  • DQP_MAIL_ACCOUNT
  • DQP_MAPI_PASSWORD
  • DQP_MAPI_PROFILE
  • DQP_NET
  • DQP_NOCPU
  • DQP_NOEXPLAIN
  • DQP_NTIER
  • DQP_PURGEHOURS
  • DQP_RECOVERY_INTERVAL
  • DQP_RES_TBLSPC
  • DQP_RUNTIME
  • DQP_SERVER
  • DQP_SHARE
  • DQP_SIBLING_WAIT
  • DQP_STARTUP
  • DQP_TRACEFILE
version 10.1 Query Patroller has been discontinued

Functionality deprecated in version 10.1

The following table shows the functionality that is deprecated in 10.1. If the functionality is discontinued, the table also shows the release where the functionality was discontinued.
Table 6. Functionality deprecated in 10.1
Functionality Discontinued in release Links to additional information
Activity monitor routines To be determined Activity monitor routines have been deprecated
Agent priority of service classes version 10.5 Agent priority of service classes is discontinued
Automatic statistics profiling version 10.5 Automatic statistics profiling is discontinued
Collations based on the Unicode Standard version 4.0.0 To be determined Collations based on the Unicode Standard version 4.0.0 have been deprecated
INSTALL_TSAMP response file keyword To be determined IBM(r) Tivoli(r) System Automation for Multiplatforms (SA MP) is now automatically installed
Net Search Extender To be determined Net Search Extender has been deprecated
DMS permanent table spaces To be determined FP1: DMS permanent table spaces are deprecated
SMS permanent table spaces To be determined SMS permanent table spaces are deprecated
Subset of version-suffixed SQL administrative routines To be determined Some version-suffixed SQL administrative routines have been deprecated
db2IdentifyType1 command version 10.5 db2IdentifyType1 command is discontinued
db2_install command To be determined db2_install command has been deprecated (Linux and UNIX)
-flushbp parameter of the db2pdcfg command To be determined -flushbp parameter of the db2pdcfg command has been deprecated
One column output by the -tcbstat parameter of the db2pd command To be determined One column output by the -tcbstat parameter of the db2pd command has been deprecated
Some parameters of the CREATE DATABASE command To be determined Some parameters of the CREATE DATABASE command have been deprecated
dynexpln command version 10.5 dynexpln command is discontinued
PRUNE LOGFILE command To be determined PRUNE LOGFILE command is deprecated
ALLOW READ ACCESS parameter of the LOAD command To be determined FP1: ALLOW READ ACCESS parameter of the LOAD command is deprecated
Some options of the REORG INDEXES/TABLE command and parameter values for related Db2 API data structures To be determined REORG INDEXES/TABLE command parameters and parameter values for related Db2 API data structures have been deprecated or discontinued
Format of the -m and -cf parameters in some commands that manage instances To be determined Some commands that manage instances have changed
ALTER DATABASE statement To be determined ALTER DATABASE statement has been deprecated
details_xml reported in logical data groups To be determined FP1: Reporting of metrics in details_xml by the statistics event monitor has been deprecated
auto_stats_prof and auto_prof_upd database configuration parameters version 10.5 Some database configuration parameters are deprecated or discontinued
health_mon database configuration parameter To be determined Some configuration parameters have been deprecated and discontinued
mincommit database configuration parameter To be determined Some configuration parameters have been deprecated and discontinued
ENHANCED_MULTIPLE_DISTINCT setting for DB2_EXTENDED_OPTIMIZATION To be determined Some registry and environment variables have changed
SNAPHADR administrative view and SNAP_GET_HADR table function To be determined Some monitoring interfaces for HADR have been deprecated
The following table shows the registry variables that are deprecated in 10.1. If the registry variables are discontinued, the table also shows the release where the registry variables were discontinued.
Table 7. Registry variables and settings that are deprecated in 10.1
Registry variables Discontinued in release Links to additional information
DB2_LIKE_VARCHAR To be determined Some registry and environment variables have been deprecated

Functionality deprecated in version 10.5

The following table shows the functionality that is deprecated in 10.5. If the functionality is discontinued, the table also shows the release where the functionality was discontinued.
Table 8. Functionality deprecated in 10.5
Functionality Discontinued in release Links to additional information
Support in COBOL and FORTRAN for db2DatabaseUpgrade To be determined COBOL and FORTRAN language support for the db2DatabaseUpgrade API is deprecated
Some SQL administrative routines are deprecated To be determined Deprecated SQL administrative routines and views
buffpage To be determined Some database configuration parameters are deprecated or discontinued
softmax database configuration parameter To be determined Some database configuration parameters are deprecated or discontinued
The following table shows the registry variables that are deprecated in 10.5. If the registry variables are discontinued, the table also shows the release where the registry variables were discontinued.
Table 9. Registry variables and settings that are deprecated in 10.5
Registry variables Discontinued in release Links to additional information
DB2_EVMON_EVENT_LIST_SIZE To be determined Some registry and environment variables have been deprecated
DB2_NCHAR_SUPPORT To be determined Some registry and environment variables have been deprecated