SDN Homepage
  My Home > MaxDB > Main > TEST ---- System Table Change 7.7.06 vs 7.8.00.10
TEST ---- System Table Change 7.7.06 vs 7.8.00.10 Welcome Guest
 View a printable version of the current page.

Added by Joerg Hoffmeister , last edited by Joerg Hoffmeister on Jan 15, 2009  (view change)
Labels: 

Removed/Renamed System Tables

SCHEMANAME TABLENAME
<SYSDBA> ALLOCATORSTATISTIC
<SYSDBA> DBTIMES
<SYSDBA> ESTIMATED_PAGES
<SYSDBA> INDEXSTATISTICS
<SYSDBA> OMS_LOCKOBJ_INFO
<SYSDBA> ROOTS
<SYSDBA> SPINLOCKS
<SYSDBA> TABLESTATISTICS
<SYSDBA> USERSTATISTICS
DOMAIN CONNECTEDUSERS
DOMAIN SYSMON_BACKUPIOACCESS
DOMAIN SYSMON_CONNECTION
DOMAIN SYSMON_IOACCESS
DOMAIN SYSMON_IOTHREAD
DOMAIN SYSMON_REGION
DOMAIN SYSMON_SPECIAL_THREAD
DOMAIN SYSMON_UKTHREAD

back to top

New System Tables

List of tables only.  For column details follow

TEST ---- New System Table Detail 780010
SCHEMANAME TABLENAME
<SYSDBA> COMMANDMONITOR
<SYSDBA> COMMANDMONITORCONSTRAINTS
<SYSDBA> COMMANDMONITORPARAMETERS
DOMAIN DATAHANDLEROPTIONDEFINITIONS
DOMAIN DATAHANDLERS
DOMAIN DATASOURCECAPABILITIES
DOMAIN DATASOURCEOPTIONS
DOMAIN DATASOURCES
DOMAIN EXTERNALTABLES
SYSINFO DATASOURCEALERTS
SYSINFO DATASOURCECONNECTIONS
SYSINFO DATASOURCEMONITOR
SYSINFO DATASOURCERUNNINGCOMMANDS
SYSINFO DATASOURCESYSTEMATTRIBUTES
SYSINFO DISTRIBUTEDTRANSACTIONS
SYSINFO LOGQUEUEINFORMATION
SYSINFO UDEPROCESSES

back to top

Altered Columns

SCHEMANAME TABLENAME COLUMNNAME DATATYPE NEWLEN NEWDEC OLDLEN OLDDEC
<SYSDBA> CONFIGURATION DESCRIPTION CHAR 8   40  
<SYSDBA> CONFIGURATION CHAR_VALUE CHAR 6   256  
<SYSDBA> LOCKLISTSTATISTICS DESCRIPTION CHAR 9   40  
<SYSDBA> LOCKLISTSTATISTICS VALUE CHAR 256   12  
<SYSDBA> LOCKSTATISTICS LOCKMODE CHAR 26   14  
<SYSDBA> LOCKSTATISTICS REQMODE CHAR 26   14  
<SYSDBA> TRANSACTIONS LOCKMODE CHAR 26   14  
<SYSDBA> TRANSACTIONS REQMODE CHAR 26   14  
DOMAIN LOCKS LOCKMODE CHAR 26   14  
DOMAIN LOCK_HOLDER LOCKMODE CHAR 26   14  
DOMAIN LOCK_REQUESTOR REQMODE CHAR 26   14  
DOMAIN LOCK_WAITS H_LOCKMODE CHAR 26   14  
DOMAIN LOCK_WAITS R_REQMODE CHAR 26   14  

back to top

Added Columns

SCHEMANAME TABLENAME COLUMNNAME LEN DEC DATATYPE
DOMAIN TABLES DATASOURCEID 8   CHAR
SYSINFO CONSISTENTVIEWS COMMANDID 8   CHAR
SYSINFO IOTHREADSTATISTICS QUEUEID 10 0 FIXED
SYSINFO IOTHREADSTATISTICS VOLUMETYPE 1   CHAR
SYSINFO IOTHREADSTATISTICSRESET QUEUEID 10 0 FIXED
SYSINFO IOTHREADSTATISTICSRESET VOLUMETYPE 1   CHAR
SYSINFO MULTIVERSIONREADSTATISTICSRESET PERCENTAGEPAGESCOPIEDFORWRITE 3 0 FIXED
SYSINFO TABLESTORAGEDETAILS SEPARATORCOUNT 10 0 FIXED
SYSINFO TABLESTORAGEDETAILS AVGUNPACKEDROWLENGTH 5 0 FIXED
SYSINFO TASKGROUPSTATISTICS THREADID 10 0 FIXED
SYSINFO TASKGROUPSTATISTICS COMMANDCOUNT 20 0 FIXED
SYSINFO TASKGROUPSTATISTICS THREADSTATE 20   CHAR
SYSINFO TASKGROUPSTATISTICS DISPATCHCOUNT 20 0 FIXED
SYSINFO TASKGROUPSTATISTICS TASKSWITCHCOUNT 20 0 FIXED
SYSINFO TASKGROUPSTATISTICSRESET COMMANDCOUNT 20 0 FIXED
SYSINFO TASKGROUPSTATISTICSRESET DISPATCHCOUNT 20 0 FIXED
SYSINFO TASKGROUPSTATISTICSRESET TASKSWITCHCOUNT 20 0 FIXED

back to top

Dropped/Renamed Columns

SCHEMANAME TABLENAME COLUMNNAME LEN DEC DATATYPE
<SYSDBA> CONFIGURATION NUMERIC_VALUE 10 0 FIXED
<SYSDBA> INDEXPAGES OWNER 32   CHAR
<SYSDBA> INDEXPAGES CHAR_VALUE 12   CHAR
<SYSDBA> INDEXPAGES DESCRIPTION 40   CHAR
SYSINFO MULTIVERSIONREADSTATISTICSRESET PAGESCOPIEDFORWRITECOUNT 20 0 FIXED  

back to top

DBAnalyzer Tables 780010

Tables utilized by DBAnalyzer. For column details follow:

DBAnalyzer Tables 7.8.00.10

back to top