
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) |
|
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 |
Database Administration in CCMS, Caches