Deprecated functionality in Db2 12.1

Functionality gets marked as deprecated when a specific function or feature is supported in the current release but might be removed in a future release. In some cases, it might be advisable to plan to discontinue the use of deprecated functionality.

Attention: The Db2 12.1 release is currently available for the following Db2 products:

Db2 Distributed (on-premises)
The container micro-service deployments of Db2 and Db2 Warehouse for Kubernetes-based clusters, which includes Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).

The following Db2 functionality is deprecated in 12.1:

Table 1. Summary of deprecated functionality in Db2 12.1
Deprecated capability	Details	Resolution
The DB2_HADR_NO_IP_CHECK registry variable	The DB2_HADR_NO_IP_CHECK registry variable is deprecated and will be discontinued in a future release.	Use the `hadr_local_host` and `hadr_local_svc` configuration parameters to specify internal and external address of an HADR host. For more information, see HADR and network address translation (NAT) support.
UNFORMATTED EVENT TABLE targets for event monitors	The UNFORMATTED EVENT TABLE target for the locking, package cache, and unit-of-work event monitors has been deprecated and might be removed in a future release.	Use WRITE TO TARGET rather than WRITE TO UNFORMATTED EVENT TABLE when creating locking, package cache, or unit-of-work event monitors.
UPDATE HISTORY FOR <object-part>	Updating history entries by passing in an object-part is now deprecated.	Use the history entry ID (EID) parameter instead. For more information, see UPDATE HISTORY command.
db2convert utility	The db2convert utility, used to convert one or all row-organized user tables to column-organized tables, is now deprecated and might be removed in a future release.	Use the ADMIN_MOVE_TABLE stored procedure directly.
IBM Database Add-Ins for specific versions of Microsoft Visual Studio.	Support for IBM Database Add-Ins for specific versions of Microsoft Visual Studio is now deprecated and could be discontinued in a future release. IBM Database Add-Ins for the following versions of Visual Studio are affected: Visual Studio 2010 Visual Studio 2012 Visual Studio 2013 Visual Studio 2015	If you have a dependency on Visual Studio, rewrite the routine logic for a Visual Studio version that is not deprecated and recreate the routine. The following Visual Studio versions are not deprecated in Db2 12.1: Visual Studio 2022 Visual Studio 2019 Visual Studio 2017
uDAPL support for RDMA communication	Db2 pureScale® no longer makes use of uDAPL for RDMA communications on any platform. This functionality is deprecated and might be removed in a future release.	This functionality is now handled using RDMA Verbs API, which performs the same functions and executes with equivalent or better performance

Table 2. Summary of deprecated routines and views in 12.1
Deprecated capability	Details	Resolution
DB2READLOG_LRI_2	Use of the db2LRI data structure parameter DB2READLOG_LRI_2 as the log record identifier (LRI) type of the db2ReadLog API is now deprecated.	Use the DB2READLOG_LRI_1 LRI type.