Upgrade impact from system catalog changes

In version 12.1, system catalog objects are modified to support new functionality. These changes can impact your existing applications and scripts after you upgrade to version 12.1.

System catalog views

The following system catalog views are changed in version 12.1. Most modifications to catalog views consist of new columns, changed descriptions, changed column data types, and increased column lengths.

New System catalog views:
  • SYSCAT.SYSPLAN_UNION
  • SYSCAT.SYSTABLES_UNION
  • SYSCAT.SYSSPATIALREFSYS_UNION
  • SYSCAT.COLPARTITIONSTATS
  • SYSCAT.COLGROUPPARTITIONSTATS
  • SYSCAT.COLDISTPARTITIONSTATS
  • SYSCAT.EXTERNALTABLEOPTIONS
  • SYSCAT.MLOPT_TABLECARDMODELS
  • sysstat.colpartitionstats
  • sysstat.colgrouppartitionstats
  • sysstat.coldistpartitionstats
  • sysstat.datapartitions
  • sysstat.indexpartitions
Catalog views that are changed in 12.1:
  • syscat.dbpartitiongroupdef
  • syscat.partitionmaps
  • SYSCAT.ST_GEOMETRY_COLUMNS
  • SYSCAT.ST_COORDINATE_SYSTEMS
  • SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS

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 are changed in version 12.1. 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, the administrative routines with names that start with SNAPSHOT are 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 other changes that might impact your applications and scripts.