In Version 10.5,
system catalog objects are modified to support new functionality.
These changes can impact your existing applications and scripts after
you upgrade to Version 10.5.
System catalog views
The
following system catalog views have changed in
Version 10.5.
Most modifications to catalog views consist of new columns, changed
descriptions, changed column data types, and increased column lengths.
- 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 10.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.
System catalog changes between pre-Version
9.7 releases
If
you are upgrading from DB2
Version
9.7,
the following additional system catalog changes between pre-
Version 10.5 releases
can also impact your applications and scripts: