Changes to system catalog views, built-in functions and global variables, built-in administrative routines and views
To support new features in Db2 version 11.1, 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
Resolution
Adjust your applications to the changes in existing system catalog objects such as new columns, or modified data type in columns. Also, start by using new system catalog objects that provide more comprehensive views or routines, or access to information about new functionality.
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.
To have access to new administrative routines in a version 11.1 fix pack release in databases that were created in version 11.1 prior to the fix pack release, you must run the db2updv111 command. If your database was created before version 11.1 and you upgrade to a version 11.1 fix pack release, it is not necessary to run the db2updv111 command because the system catalog is automatically updated by the database upgrade.