Summary of deprecated and discontinued Db2 functionality in version 11.5 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:
- Functionality deprecated in version 10.5
- Functionality deprecated in version 11.1
- Functionality deprecated in version 11.5
Note:
- Pointers to supplemental information are provided if available.
- Information about deprecated functionality for add-on features such as Spatial Extender is not included.
- 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:
| Release | Links to additional information |
|---|---|
| version 10.5 | |
| version 11.1 | |
| version 11.5 |
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.
| 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.
| Registry variables | Discontinued in release | Links to additional information |
|---|---|---|
| DB2_EVMON_EVENT_LIST_SIZE | To be determined | Some registry and environment variables are deprecated |
| DB2_NCHAR_SUPPORT | To be determined | Some registry and environment variables are deprecated |
Functionality deprecated in version 11.1
The following table shows the functionality that is deprecated in 11.1. If the functionality is discontinued, the table also shows the release where the functionality was discontinued.
| Functionality | Discontinued in release | Links to additional information |
|---|---|---|
| Private sort memory |
To be determined |
Deprecated functionality in Version 11.1 |
| Intelligent Mining |
To be determined |
Deprecated functionality in Version 11.1 |
| Text Analytics |
To be determined |
Deprecated functionality in Version 11.1 |
| Resource Description Framework (RDF) application development |
version 11.5 |
Deprecated functionality in Version 11.1 |
The following table shows APIs, commands, command parameters, monitor elements, and statements that are deprecated in 11.1:
| Functionality | Discontinued in release | Links to additional information |
|---|---|---|
| -disk suboption |
To be determined |
Deprecated functionality in Version 11.1 |
| db2tapemgr |
To be determined |
Deprecated functionality in Version 11.1 |
| db2top |
To be determined |
Deprecated functionality in Version 11.1 |
| SET PASSWORD |
To be determined |
Deprecated functionality in Version 11.1 |
| GETHINT |
To be determined |
Deprecated functionality in Version 11.1 |
| ENCRYPT |
To be determined |
Deprecated functionality in Version 11.1 |
| DECRYPT_BIN |
To be determined |
Deprecated functionality in Version 11.1 |
| DECRYPT_CHAR |
To be determined |
Deprecated functionality in Version 11.1 |
Functionality deprecated in version 11.5
The following table shows the functionality that is deprecated in 11.5. If the functionality is discontinued, the table also shows the release where the functionality was discontinued.
| Deprecated capability | Details | Resolution |
|---|---|---|
| TLS 1.0 and 1.1 | The use of versions 1.0 and 1.1 of the Transport Layer Security (TLS) protocol has been deprecated. | TLS is the Secure Socket Layer (SSL) protocol used by Db2 to provide secure, encrypted transmission of data. We recommend using TSL version 1.2. |
| Infiniband network in GDPC on AIX | Support of using Infiniband network as private network between members and CFs in geographically dispersed pureScale cluster (GDPC) on AIX has been deprecated. It will be discontinued in a future release. | New instances should use RoCE network with 4 switch configuration as private network between members and CFs that provides full redundancy at adapter and switch level. |
| Functionality | Discontinued in release | Links to additional information |
|---|---|---|
| db2ReadLogNoConn |
To be determined |
Deprecated functionality in Db2 11.5 |
| db2ReadLogNoConnInit |
To be determined |
Deprecated functionality in Db2 11.5 |
| db2ReadLogNoConnTerm |
To be determined |
Deprecated functionality in Db2 11.5 |
| The DATA_ENCRYPT authentication type |
To be determined |
Deprecated functionality in Db2 11.5 |
| The 3DES encryption option |
To be determined |
Deprecated functionality in Db2 11.5 |
| DB2INSTDEF |
To be determined |
Deprecated functionality in Db2 11.5 |