Manageability enhancements

Db2 11.5.1 provides enhancements that make it easier to manage Db2 environments, minimize the total cost of ownership (TCO), reduce the impact of performing system management tasks, and extend the capabilities of the autonomic features introduced in previous releases.

Note: The enhancements in this topic are included in the Db2 11.5.1 mod pack release, which is available for the following Db2 products:

The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
The container micro-service deployment of Db2 on Red Hat OpenShift
The Db2 cartridge used by IBM Cloud Pak for Data

The following table lists manageability enhancements that have been added to the container-only release of Db2 11.5.1:

Table 1. Manageability enhancements in 11.5.1
Enhancement	Description
New buffered scan option available in the EXPLAIN_ARGUMENT table	A new column, BUFFSCAN, provides the option of enabling a buffered scan. Scan results can identify which access method was used on a row, in the event of a performance issue.
Ability to lift or enforce locks placed on tables by INSERT operations	A new registry variable, `DB2_INSERT_RELEASE_LOCK_ON_DUP`, has been added, that allows users to enforce or lift locks on tables caused by INSERT operations.
External storage enhancements to the CREATE EXTERNAL TABLE statement	CREATE EXTERNAL TABLE statement now supports data storage on Microsoft Azure Blob Storage, with the ability to query the data.