Show TOC

DATACACHELocate this document in the navigation structure

Definition

The system table SYSINFO.DATACACHE describes the areas of the data cache.

Structure

USABLESIZE

FIXED(20)

Size of the data cache (KB)

USEDSIZE

FIXED(20)

Used area of the data cache (KB)

MAXUSEDSIZE

FIXED(20)

Maximum used area of the data cache (KB)

OMSDATASIZE

FIXED(20)

Size of the area of the data cache that is used for storing the OMS data (KB)

OMSUNLOADEDVERSIONSIZE

FIXED(20)

Size of the OMS versions that were displaced from the main memory for space reasons (KB)

HISTORYDATASIZE

FIXED(20)

Size of the area of the data cache that is required for consistent reads and transaction management (KB)

SQLDATASIZE

FIXED(20)

Size of the area of the data cache that is not required either for OMS or for consistent reads and transaction management (KB)

CHANGEDDATASIZE

FIXED(20)

Amount of changed data since the last savepoint that has to be written to data area at next savepoint (KB)

PENDINGOPERATIONCOUNT

FIXED(10)

Number of structure-changing operations that need to be included in the next savepoint

USEDPINAREASIZE

FIXED(20)

Size of the area of the data cache that is used for storing data which should not be replaced (KB)

USABLEPINAREASIZE

FIXED(20)

Maximim size of the data cache that could be used for data which should not be replaced (KB)

SAVEPOINTREQUESTCOUNT

FIXED(20)

Number of savepoints requested by the data cache

DISPLACEMENTREQUESTCOUNT

FIXED(20)

Number of attempts to displace modified pages from the cold end of the data cache LRU list

More Information

Database Administration in CCMS, Caches