To prepare the data snapshot, execute the following HDBSQL command:
BACKUP DATA FOR FULL SYSTEM CREATE SNAPSHOT COMMENT 'SNAPSHOT-<Snapshot Time>
Note:
Once the Data Snapshot has been prepared it should not be retained for a long period of time. If it is left in the "prepared" state new data will be written to a different part of the data volume and it will eventually fill and run out of space.
To retrieve the Backup ID, execute the following HDBSQL command:
SELECT BACKUP_ID, COMMENT FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'data snapshot' AND STATE_NAME = 'prepared'
The Backup_ID value is important, it will be needed to either confirm or abandon the data snapshot.