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 will appear 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 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.