Definitions of the System Tables

The database system contains a series of system tables. You will find a definition of some system tables here, which contain information about database objects and their connection to each other, statistics system tables, monitor system tables and loader system tables.

System Tables with Information About Database Objects

The database system contains a series of system tables with information about the database objects and their relationships to each other. These system tables are available in the DOMAIN schema in every SQL mode. You have to specify the schema to access these tables in every SQL mode other than INTERNAL.

DOMAIN System Tables
COLUMNS	CONSTRAINTCOLUMNS	CONSTRAINTS
DBPROCEDURES	DBPROCPARAMS	DOMAINCONSTRAINTS
DOMAINS	FOREIGNKEYCOLUMNS	FOREIGNKEYS
FUNCTIONS	INDEXCOLUMNS	INDEXES
LOCKS	LOCK_WAITS	MAPCHARSETS
PACKAGES	ROLEPRIVILEGES	ROLES
SCHEMAPRIVILEGES	SCHEMAS	SEQUENCEPRIVILEGES
SEQUENCES	SESSION_ROLES	SYNONYMS
SYSTEMTRIGGERS	TABLEPRIVILEGES	TABLES
TRIGGERS	USERS	VIEWCOLUMNS
VIEWDEFS	VIEWS	VIEWTABLES

System Tables with Information About Database States

The database system contains a series of system tables with information about the system configuration and system load. These system tables are available in the SYSINFO schema in every SQL mode. You do not need to specify the schema to access these tables.

SYSINFO System Tables
ACTIVECONFIGURATION	BACKUPTHREADS	CACHESTATISTICS
CATALOGCACHESTATISTICS	COMMANDCACHESTATISTICS	COMMANDCACHESTATISTICSRESET
COMMANDSTATISTICS	COMMANDSTATISTICSRESET	CONSISTENTVIEWOPENTRANSACTIONS
CONSISTENTVIEWS	CONVERTERMAPPING	DATACACHE
DATASTATISTICS	DATASTATISTICSRESET	‎DATAVOLUMES
FILEDIRECTORIES	FILES	FILESYSTEMS
FREEBLOCKMANAGERBLOCKSTATES	FREEBLOCKMANAGERSECTIONS	FREEBLOCKMANAGERSTATISTICS
FREEBLOCKMANAGERSTATISTICSRESET	HISTORYCLEANUPSTATISTICS	HISTORYCLEANUPSTATISTICSRESET
HOTSTANDBYCOMPONENT	HOTSTANDBYGROUP	INDEXSIZE
INDEXSTORAGEDETAILS	INSTANCE	IOBUFFERCACHES
IOJOBS	IOTHREADSTATISTICS	IOTHREADSTATISTICSRESET
LOCKSTATISTICS	LOCKSTATISTICSRESET	LOCKSTATISTICSRESET
LOGPARTITIONSTATISTICS	LOGQUEUEINFORMATION	LOGQUEUESTATISTICS
LOGQUEUESTATISTICSRESET	LOGSTATISTICS	LOGSTATISTICSRESET
LOGVOLUMES	MACHINECONFIGURATION	MACHINEUTILIZATION
MEMORYALLOCATORDETAILS	MEMORYALLOCATORSTATISTICS	MULTIVERSIONREADSTATISTICS
MULTIVERSIONREADSTATISTICSRESET	OMSPROCEDURESTATISTICS	OMSVERSIONS
OPTIMIZERINFORMATION	PAGELOCKS	REGIONINFORMATION
REGIONSTATISTICS	REGIONSTATISTICSRESET	RESTARTINFORMATION
SCHEMASIZE	SERVERTASKS	SESSIONS
SHARELOCKINFORMATION	SHARELOCKSTATISTICS	SHARELOCKSTATISTICSRESET
SHARELOCKWAITINGTASKS	SNAPSHOTS	SPINLOCKPOOLSTATISTICS
SPINLOCKSTATISTICS	SPINLOCKPOOLSTATISTICSRESET	SPINLOCKSTATISTICSRESET
TABLESIZE	TABLESTORAGEDETAILS	TASKGROUPSTATISTICS
TASKGROUPSTATISTICSRESET	TASKLOADBALANCINGINFORMATION	TASKLOADBALANCINGTASKGROUPSTATES
TASKLOADBALANCINGTASKMOVES	TRANSACTIONHISTORY	TRANSACTIONS
UNLOADEDSTATEMENTS	VERSION

Statistics System Tables

The database system contains a number of system tables that you can use to select information about the configuration, structures, and sizes of database objects. These statistics system tables are available in the database system administrator schema. You do not need to specify the schema to access these tables.

Statistics System Tables
SYSCHECKSTATISTICSDETAILS	SYSCHECKSTATISTICSLOG	SYSUPDATECOUNTERWANTED
SYSUPDSTATLOG	SYSUPDSTATWANTED

Monitor System Tables

The database system contains a number of system tables that you can use to access monitor information. These monitor system tables are available in the database system administrator schema. You do not need to specify the schema to access these tables.

The monitor system tables return results for the database system administrator and for all users of the database user class database administrator (DBA user). Unauthorized users receive error message 100 – row not found

Many monitor system tables are structured as follows:

Monitor System Table Structure
`DESCRIPTION`	CHAR(40)
`VALUE`	FIXED(20)

Each row contains a counter value that is described by the value contained in the DESCRIPTION column.

Monitor System Tables
COMMANDMONITOR	MONITOR	MONITOR_LOAD
MONITOR_LOB	MONITOR_LOCK	MONITOR_PAGES
MONITOR_REWRITE	MONITOR_ROW	MONITOR_TRANS

Loader System Tables

The database system contains a range of Loader system tables that are used by the Loader. These Loader system tables are available in the SYSLOADER schema. You need to specify the schema SYSLOADER to access these tables.

SYSLOADER System Tables
CODEPAGE	MAPSCHEMANAMES	TRANSFORMATIONMODEL
TRANSFORMATIONMONITOR	TRANSFORMATIONPACKAGES	TRANSFORMATIONRESOURCES
TRANSFORMATIONSTATISTICS	TRANSFORMATIONSTEPS

System Tables Upgrade

These upgrade system tables are available in the database system administrator schema and are only visible for the database system administrator.

System Tables Upgrade
POSTUPGRADECHECKLIST	POSTUPGRADECHECKLIST<version>	POSTUPGRADECHECKLISTUNICODE
SYSUPGRADEHISTORY

More Information

System Tables