Object documentationDATACACHE Locate this document in the navigation structure

 

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

Structure

DATACACHE

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)

More Information

Database Administratin in CCMS, Caches