Release | Links to additional information |
---|---|
Version 9.7 | |
Version 10.1 | |
Version 10.5 |
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 |
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:
|
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:
|
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 |
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:
|
Version 10.1 | Query Patroller has been discontinued |
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 |
Registry variables | Discontinued in release | Links to additional information |
---|---|---|
DB2_LIKE_VARCHAR | To be determined | Some registry and environment variables have been deprecated |
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 |
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 |