Object documentationSNAPSHOTS Locate this document in the navigation structure

 

The system table SYSINFO.SNAPSHOTS contains information about a defined view (snapshot) of the data.

Structure

SNAPSHOTS

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

More Information

Database Administration, Making Snapshots of the Data Area