Changes to database objects and functions in Db2 11.5

Details

Built-in administrative views and routine changes

The following administrative views and routines are changed in version 11.5. Most modifications consist of new columns, new values, changed column data types, and increased column lengths:

• MON_GET_ACTIVITY table function - Return a list of activities
• MON_GET_ACTIVITY_DETAILS table function - Return information about an activity as an XML document
• MON_GET_PKG_CACHE_STMT table function - Get package cache statement metrics
• MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics
• MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses
• MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses
• MON_GET_TRANSACTION_LOG table function - Get log information
• MON_GET_WORKLOAD table function - Get workload metrics
• MON_GET_WORKLOAD_STATS table function - Return workload statistics
• MON_GET_UNIT_OF_WORK table function - Get unit of work metrics
• MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document

The following monitor routines and views are new:

• MON_GET_SERVICE_SUPERCLASS table function - Get service superclass metrics
• MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get service superclass metrics as an XML document

Resolution

Review the list of the deprecated administrative routines and the associated replacement routines or views to determine any additional changes that might impact your applications and scripts. To minimize the impact of changes to built-in routines and views, review Best practices for calling built-in routines and views in applications.

For a list of the data dictionary-compatible views, see Data dictionary-compatible views.