Changes to database objects and functions in Db2 11.5.6

To support new features in Db2 11.5.6, database catalog objects such as system catalog views, built-in functions and global variables, built-in administrative routines and views are new and modified.

Details

Commands
The following commands are changed in 11.5.6:
Enhancement Description

The installFixPack command will now prompt users with a license agreement

This new license agreement appears unless users pass the new, mandatory -y parameter. For more information, refer to -y command parameter usage.

Robust Db2 pureScale® diagnostic paths

Improved DIAGPATH, CF_DIAGPATH, and ALT_DIAGPATH database manager parameter restrictions to help ensure optimal transactional throughput and minimal time-to-recover. For more information, refer to Changes to database manager configuration parameters in Db2 11.5.6.

The command line processor (CLP) queue name hashing algorithm has been updated The CLP queue name hashing algorithm has been improved to avoid key collision, and to accept a higher range of processor IDs (PID) and user IDs (UID) for newer operating systems.
Note: This design change introduces a limitation in the Korn shell on AIX® when using the su command within the same command line processor (CLP) session. In this scenario, you cannot run Db2 commands as another Db2 instance user if the UID modulo 8 operation (UID % 8) results in the same value for both UIDs. Otherwise, DB21016E is returned.
Default Fast Communication Manager (FCM) and service ports have been updated The Default Fast Communication Manager (FCM) and service ports have been updated to comply with the new Berkeley Software Distribution (BSD) standards. For more information, refer to Db2 server TCP/IP port numbers.
Federation server DRDA wrapper and Net8 wrappers In release 11.5.5 and earlier, the DRDA AS400 and Oracle Net8 wrappers keep the nickname column length identical to the remote table column length for CHAR data type, even when the code point size differs between the federation server and the remote data source. This might lead to character truncation issues. Starting with the 11.5.6 release, the column length is extended automatically based on a factor derived from the code pages of the federation server and the remote data source to prevent such truncation.