SYSCS_UTIL.SNAPSHOT_SCHEMA system procedure creates a Splice
Machine snapshot of the specified schema. These snapshots can
subsequently be used to restore the schema to its state at the time that
a snapshot was created.
Snapshots include both the data and indexes for tables.
For more information, see the Using Snapshots topic.
SYSCS_UTIL.SNAPSHOT_SCHEMA( VARCHAR(128) schemaName, VARCHAR(128) snapshotName );
The name of the schema for which you are creating a snapshot.
The name that you are assigning to this snapshot, which you can subsequently use to restore or delete the snapshot.
This procedure does not return a result.
Creating a schema snapshot can require several minutes of more to complete, depending on the size of the schema.
The following example creates a snapshot of the schema named
splice> CALL SYSCS_UTIL.SNAPSHOT_SCHEMA('mySchema', 'snap_myschema_070417a'); Statement executed.