Changes to database objects and functions in Db2 11.5.2

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

Attention: Changes in version 11.5.2 affect only single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)

Details

Built-in function changes

The following built-in functions are changed in version 11.5.2:

MON_GET_HADR table function - Returns high availability disaster recovery (HADR) monitoring information
The MON_GET_HADR table function returns high availability disaster recovery (HADR) monitoring information. A new column, HADR_LAST_TAKEOVER_TIME, of type TIMESTAMP, has been added to report, for a particular database, when the HADR_ROLE last changed from STANDBY to PRIMARY.