The system table SYSINFO.DATACACHE describes the areas of the data cache.
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) |
Database Administratin in CCMS, Caches