SYSCS_UTIL.SNAPSHOT_TABLE system procedure creates a Splice
Machine snapshot of the specified table. These snapshots can
subsequently be used to restore the table 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_TABLE( VARCHAR(128) schemaName, VARCHAR(128) tableName, VARCHAR(128) snapshotName );
The name of the table’s schema.
The name of the table 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 table snapshot can require several minutes of more to complete, depending on the size of the table.
The following example creates a snapshot of the table named
splice> CALL SYSCS_UTIL.SNAPSHOT_TABLE('mySchema', 'myTable', 'snap_myschema_070417a'); Statement executed.