SYSCS_UTIL.SYSCS_DELETE_OLD_BACKUPS

The SYSCS_UTIL.SYSCS_DELETE_OLD_BACKUPS system procedure deletes any backups that are older than a specified number of days (the backup window), retaining only those backups that fit into that window.

Backups can consume a lot of disk space, and thus, we recommend regularly scheduling both the creation of new backups and deletion of outdated backups.

Syntax

SYSCS_UTIL.SYSCS_DELETE_OLD_BACKUPS( INT backupWindow );

backupWindow

Specifies the number of days of backups that you want retained. Any backups created more than backupWindow days ago are deleted.

See the Backing Up and Restoring topic in our Administrator’s Guide for more information.

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

SQL Example

The following example deletes all database backups that were created more than 30 days ago.

splice> CALL SYSCS_UTIL.SYSCS_DELETE_OLD_BACKUPS(30);
Statement executed.

See Also