Administrative Procedures and Functions

These are the system procedures and functions for administering your database:

Procedure / Function Name Description

Backs up the database to a specified backup directory.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}

Cancels a backup.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}

Cancels a scheduled daily backup.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}
SYSCS_UTIL.CHECK_TABLE Reports on inconsistencies between a table and its indexes.
SYSCS_UTIL.SYSCS_CREATE_USER Adds a new user account to a database.

Delete a specific backup.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}

Deletes all backups that were created more than a certain number of days ago.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}
SYSCS_UTIL.SYSCS_DROP_USER Removes a user account from a database.
SYSCS_UTIL.INVALIDATE_DICTIONARY_CACHE Invalidates the dictionary cache on the connection's region server.
SYSCS_UTIL.INVALIDATE_GLOBAL_DICTIONARY_CACHE Invalidates the dictionary cache on all region servers.
SYSCS_UTIL.KILL_OPERATION Terminates a Splice Machine operation running on the server to which you are connected.
SYSCS_UTIL.SYSCS_MODIFY_PASSWORD Called by a user to change that user's own password.
SYSCS_UTIL.SYSCS_PERFORM_MAJOR_COMPACTION_ON_SCHEMA Performs a major compaction on a schema
SYSCS_UTIL.SYSCS_PERFORM_MAJOR_COMPACTION_ON_TABLE Performs a major compaction on a table.
SYSCS_UTIL.SYSCS_REFRESH_EXTERNAL_TABLE Refreshes the schema of an external table in Splice Machine; use this when the schema of the table's source file has been modified outside of Splice Machine.
SYSCS_UTIL.SYSCS_RESET_PASSWORD Resets a password that has expired or has been forgotten.

Restores a database from a previous backup.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}

Schedules a full or incremental database backup to run at a specified time daily.

    [Learn about our products]({: target="_blank"} {: .noteOnPremiseOnly}
SYSCS_UTIL.SYSCS_UPDATE_SCHEMA_OWNER Changes the owner of a schema.
SYSCS_UTIL.VACUUM Performs clean-up operations on the system.