V9与V10的NEW FEATURE

This release of DB2® for z/OS® includes many new catalog tables as well as many catalog tables that have new or changed content.

Descriptions of the following catalog tables have been added:

• SYSIBM.SYSAUDITPOLICIES
• SYSIBM.SYSAUTOALERTS
• SYSIBM.SYSAUTOALERTS_OUT
• SYSIBM.SYSAUTORUNS_HIST
• SYSIBM.SYSAUTORUNS_HISTOU
• SYSIBM.SYSAUTOTIMEWINDOWS
• SYSIBM.SYSCONTROLS
• SYSIBM.SYSDUMMYA
• SYSIBM.SYSDUMMYE
• SYSIBM.SYSDUMMYU
• SYSIBM.SYSINDEXES_RTSECT
• SYSIBM.SYSINDEXES_TREE
• SYSIBM.SYSPACKCOPY
• SYSIBM.SYSPACKSTMT_STMB
• SYSIBM.SYSPACKSTMT_STMT
• SYSIBM.SYSPENDINGDDL
• SYSIBM.SYSPENDINGOBJECTS
• SYSIBM.SYSQUERY
• SYSIBM.SYSQUERY_AUX
• SYSIBM.SYSQUERYOPTS
• SYSIBM.SYSQUERYPLAN
• SYSIBM.SYSROUTINES_TREE
• SYSIBM.SYSS_PROFILES
• SYSIBM.SYSS_PROFILE_TEXT
• SYSIBM.SYSTRIGGERS_STMT
• SYSIBM.SYSVIEWS_STMT
• SYSIBM.SYSVIEWS_TREE
• SYSIBM.SYSXMLTYPMOD
• SYSIBM.SYSXMLTYPMSCHEMA

The catalog tables that are listed in the following table have new or revised columns, column values, or column descriptions to support the new function in this release of DB2 for z/OS.

Table 1. Summary of new and revised catalog table columns

Catalog table name	New column	Revised column
SYSIBM.SYSCHECK	PERIOD
SYSIBM.SYSCOLUMNS	HASHKEY_COLSEQ CONTROL_ID XML_TYPMOD_ID PERIOD GENERATED_ ATTRIBUTE	COLTYPE LENGTH SCALE DEFAULT
SYSIBM.SYSCOPY		ICBACKUP STYPE TTYPE
SYSIBM.SYSDATATYPES	INLINE_LENGTH	SCALE
SYSIBM.SYSDBAUTH		AUTHHOWGOT
SYSIBM. SYSDEPENDENCIES	BVERSION DVERSION	BNAME BTYPE
SYSIBM.SYSINDEXES	HASH SPARSE ROWID	UNIQUERULE INDEXTYPE UNIQUE_COUNT
SYSIBM.SYSINDEXPART		STORNAME SPACE
SYSIBM. SYSINDEXSPACESTATS	REORGINDEXACCESS DRIVETYPE	NPAGES
SYSIBM. SYSKEYCOLUSE	PERIOD
SYSIBM.SYSKEYS	PERIOD	ORDERING
SYSIBM. SYSKEYTARGETS		LENGTH SCALE
SYSIBM. SYSOBJROLEDEP		DTYPE
SYSIBM.SYSPACKAGE	LASTUSED CONCUR_ACC_RES EXTENDED- INDICATOR PLANMGMT PLANMGMTSCOPE APRETAINDUP RECORD- TEMPORALHIST	HOSTLANG TYPE
SYSIBM.SYSPACKAUTH		AUTHHOWGOT
SYSIBM.SYSPACKDEP		BNAME BQUALIFIER BTYPE DTYPE
SYSIBM.SYSPACKSTMT	ROWID STATEMENT STMT_ID	SEQNO
SYSIBM.SYSPARMS		SCALE
SYSIBM.SYSPLAN	LASTUSED CONCUR_ACC_RES
SYSIBM.SYSPLANAUTH		AUTHHOWGOT
SYSIBM.SYSRESAUTH		AUTHHOWGOT
SYSIBM. SYSROUTINEAUTH		AUTHHOWGOT
SYSIBM.SYSROUTINES	SECURE INLINE SYSTEM_DEFINED	VERSION
SYSIBM. SYSSCHEMAAUTH		AUTHHOWGOT
SYSIBM. SYSSEQUENCEAUTH		AUTHHOWGOT
SYSIBM.SYSSTMT		SEQNO
SYSIBM.SYSTABAUTH		AUTHHOWGOT
SYSIBM.SYSTABLEPART	HASHSPACE HASHDATAPAGES	STORNAME PERCACTIVE CHECKFLAG
SYSIBM.SYSTABLES	HASHKEY- COLUMNS CONTROL VERSIONING_ SCHEMA VERSIONING_ TABLE	TYPE
SYSIBM.SYSTABLESPACE	MEMBER_ CLUSTER ORGANIZATION- TYPE HASHSPACE HASHDATA- PAGES	DSSIZE
SYSIBM. SYSTABLESPACESTATS	REORGSCAN- ACCESS REORGHASH- ACCESS HASHLASTUSED REORG- CLUSTERSENS DRIVETYPE LPFACILITY
SYSIBM.SYSTRIGGERS	SECURE ALTEREDTS ROWID STATEMENT
SYSIBM.SYSUSERAUTH	EXPLAINAUTH SQLADMAUTH SDBADMAUTH DATAACCESSAUTH ACCESSCTRLAUTH CREATE- SECUREAUTH	AUTHHOWGOT
SYSIBM.SYSVIEWS	ROWID STATEMENT