Some system catalog views, system-defined administrative routines and views have been added and changed

System catalog view changes

The following system catalog views have changed in Version 9.7. Most modifications to catalog views consist of new columns, changed descriptions, changed column data types, and increased column lengths.

• SYSCAT.ATTRIBUTES
• SYSCAT.BUFFERPOOLS
• SYSCAT.CASTFUNCTIONS
• SYSCAT.COLUMNS
• SYSCAT.CONSTDEP
• SYSCAT.DATAPARTITIONS
• SYSCAT.DATATYPES
• SYSCAT.DBAUTH
• SYSCAT.HISTOGRAMTEMPLATEUSE
• SYSCAT.INDEXDEP
• SYSCAT.INDEXES
• SYSCAT.INDEXEXTENSIONDEP
• SYSCAT.INVALIDOBJECTS
• SYSCAT.PACKAGEDEP
• SYSCAT.PACKAGES
• SYSCAT.ROUTINEDEP
• SYSCAT.ROUTINEPARMS
• SYSCAT.ROUTINES
• SYSCAT.SECURITYPOLICIES
• SYSCAT.SEQUENCES
• SYSCAT.SERVICECLASSES
• SYSCAT.TABDEP
• SYSCAT.TABDETACHEDDEP
• SYSCAT.TABLES
• SYSCAT.TABLESPACES
• SYSCAT.THRESHOLDS
• SYSCAT.TRIGDEP
• SYSCAT.VARIABLEDEP
• SYSCAT.VARIABLES
• SYSCAT.WORKCLASSES
• SYSCAT.WORKLOADS
• SYSCAT.XSROBJECTDEP
• SYSSTAT.COLGROUPS
• SYSSTAT.COLUMNS
• SYSSTAT.INDEXES

The following system catalog views have been added in Version 9.7:

• SYSCAT.CONDITIONS
• SYSCAT.DATATYPEDEP
• SYSCAT.INDEXPARTITIONS
• SYSCAT.INVALIDOBJECTS
• SYSCAT.MODULEAUTH
• SYSCAT.MODULEOBJECTS
• SYSCAT.MODULES
• SYSCAT.ROWFIELDS
• SYSCAT.XMLSTRINGS
• SYSCAT.XSROBJECTDETAILS

System-defined administrative views and routine changes

The following administrative views and routines have changed in Version 9.7:

• ADMIN_CMD procedure
• ADMINTABCOMPRESSINFO administrative view and ADMIN_GET_TAB_COMPRESS_INFO table function
• ADMINTABINFO administrative view and ADMIN_GET_TAB_INFO_V97
• AUTH_LIST_AUTHORITIES_FOR_AUTHID table function
• DBMCFG administrative view
• REBIND_ROUTINE_PACKAGE routine
• REORGCHK_IX_STATS
• SNAPAPPL_INFO administrative view and SNAP_GET_APPL_INFO_V95 table function
• SNAPSTORAGE_PATHS administrative view and SNAP_GET_STORAGE_PATHS_V97 table function
• SNAPTBSP_PART administrative view and SNAP_GET_TBSP_PART_V97 table function
• SYSINSTALLOBJECTS (starting in Version 9.7 Fix Pack 1)
• WLM_GET_SERVICE_SUBCLASS_STATS_V97 table function

The following table functions have been deprecated in Version 9.7:

• HEALTH_CONT_HI
• HEALTH_CONT_HI_HIS
• HEALTH_CONT_INFO
• HEALTH_DB_HI
• HEALTH_DB_HI_HIS
• HEALTH_DB_HIC
• HEALTH_DB_HIC_HIS
• HEALTH_DB_INFO
• HEALTH_DBM_HI
• HEALTH_DBM_HI_HIS
• HEALTH_DBM_INFO
• HEALTH_GET_ALERT_ACTION_CFG
• HEALTH_GET_ALERT_CFG
• HEALTH_GET_IND_DEFINITION
• HEALTH_HI_REC
• HEALTH_TBS_HI
• HEALTH_TBS_HI_HIS
• HEALTH_TBS_INFO
• SNAP_GET_LOCK (deprecated starting in Version 9.7 Fix Pack 1)
• SNAP_GET_LOCKWAIT (deprecated starting in Version 9.7 Fix Pack 1)
• SNAP_GET_STORAGE_PATHS
• SNAP_GET_TBSP_PART_V91
• WLM_GET_ACTIVITY_DETAILS
• WLM_GET_SERVICE_CLASS_AGENTS
• WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES
• WLM_GET_SERVICE_SUBCLASS_STATS
• WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES
• WLM_GET_WORKLOAD_STATS

The following administrative views have been deprecated in Version 9.7 Fix Pack 1:

• SNAPLOCK
• SNAPLOCKWAIT
• LOCKS_HELD
• LOCKWAITS

User response

To have access to new administrative routines in Version 9.7 Fix Pack 1 in databases created in Version 9.7 prior to Fix Pack 1, you must have already run the db2updv97 command. If your database was created before Version 9.7, it is not necessary to run the db2updv97 command (because the system catalog is automatically updated by the database upgrade).

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.

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

To minimize the impact of changes to system-defined routines and views, review Best practices for calling system-defined routines and views in applications.