SYSCS_UTIL.SYSCS_SNAPSHOT_SCHEMA

The SYSCS_UTIL.SYSCS_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.

Syntax

SYSCS_UTIL.SYSCS_SNAPSHOT_SCHEMA( VARCHAR(128) schemaName,
                                  VARCHAR(128) snapshotName );

schemaName

The name of the schema for which you are creating a snapshot.

snapshotName

The name that you are assigning to this snapshot, which you can subsequently use to restore or delete the snapshot.

Results

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.

Example

The following example creates a snapshot of the schema named mySchema:

splice> CALL SYSCS_UTIL.SNAPSHOT_SCHEMA('mySchema', 'snap_myschema_070417a');
Statement executed.