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.
SYSCS_UTIL.SYSCS_DELETE_OLD_BACKUPS( INT 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.
This procedure does not return a result.
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.
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.