SNAPSHOTS
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