The system table SYSINFO.SNAPSHOTS contains information about a defined view (snapshot) of the data.
ID |
FIXED(10) |
Current converter version when the snapshot was defined |
CREATEDATE |
TIMESTAMP |
Time at which the snapshot was defined |
USEDSIZE |
FIXED(20) |
Amount of data used for the snapshot (KB) |
MAXNEEDEDSIZE |
FIXED(20) |
Maxium obtainable snapshot size if there was one change to all pages which existed when the snapshot was made (KB) |
TRANSACTIONCONSISTENT |
CHAR(3) |
The snapshot contains no open transactions (YES) or does contain open transactions (NO) |
COMMENT |
CHAR(60) |
Additional Notes |
Database Administration in CCMS, Snapshots
Database Administration, Snapshot of the Data Area