Upgrade impact from system catalog changes
In version 11.5, system catalog objects are modified to support new functionality. These changes can impact your existing applications and scripts after you upgrade to version 11.5.
System catalog views
- SYSCAT.ATTRIBUTES catalog view
- SYSCAT.CHECKS catalog view
- SYSCAT.COLUMNS catalog view
- SYSCAT.CONTROLS catalog view
- SYSCAT.DATATYPES catalog view
- SYSCAT.INDEXCOLUSE catalog view
- SYSCAT.INDEXES catalog view
- SYSCAT.PACKAGES catalog view
- SYSCAT.ROUTINEPARMS catalog view
- SYSCAT.ROUTINES catalog view
- SYSCAT.ROWFIELDS catalog view
- SYSCAT.SERVICECLASSES catalog view
- SYSCAT.STOGROUPS catalog view
- SYSCAT.TABDEP catalog view
- SYSCAT.TABLES has a new column that is called TABLEORG to indicate the table organization
- SYSCAT.TABLESPACES catalog view
- SYSCAT.TRIGGERS catalog view
- SYSCAT.VARIABLES catalog view
- SYSCAT.VIEWS catalog view
- SYSSTAT.COLUMNS catalog view
- SYSSTAT.INDEXES catalog view
- SYSSTAT.TABLES catalog view
For more information, see Some system catalog views, built-in functions and global variables, built-in administrative routines and views have been added and changed for details.
Built-in administrative views and routines
The following administrative views and routines have changed in version 11.5. Most modifications consist of new columns, new values, changed column data types, and increased column lengths:- ADMINTABINFO administrative view and ADMIN_GET_TAB_INFO table function
- ENV_SYS_INFO administrative view
- MON_BP_UTILIZATION administrative view
- MON_CONNECTION_SUMMARY administrative view
- MON_CURRENT_SQL administrative view
- MON_DB_SUMMARY administrative view
- MON_FORMAT_XML_COMPONENT_TIMES_BY_ROW table function
- MON_FORMAT_XML_METRICS_BY_ROW table function
- MON_FORMAT_XML_TIMES_BY_ROW table function
- MON_GET_APPL_LOCKWAIT table function
- MON_GET_BUFFERPOOL table function
- MON_GET_CONNECTION table function
- MON_GET_CONNECTION_DETAILS table function
- MON_GET_PKG_CACHE_STMT table function
- MON_GET_SERVICE_SUBCLASS table function
- MON_GET_SERVERLIST table function
- MON_GET_TABLE table function
- MON_GET_TABLESPACE table function
- MON_GET_TABLE_USAGE_LIST table function
- MON_TBSP_UTILIZATION administrative view
- MON_GET_UNIT_OF_WORK
- MON_GET_UNIT_OF_WORK_DETAILS
- MON_GET_WORKLOAD table function
- MON_GET_WORKLOAD_DETAILS table function
- MON_WORKLOAD_SUMMARY administrative view
For more information, see Some system catalog views, built-in functions and global variables, built-in administrative routines and views have been added and changed for details.
In addition, all of the administrative routines with names that start with SNAPSHOT have been deprecated since Db2® Version 9.1. For more information, see Some system catalog views, built-in functions and global variables, built-in administrative routines and views have been added and changed for details.
Review the list of the deprecated administrative routines and their replacement routines or views to determine additional changes that might impact your applications and scripts.