Background documentationDefinitions of the System Tables Locate this document in the navigation structure

 

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.

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.

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.

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.

System Tables Upgrade

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

More Information

System Tables