Deleting a schema-level backup

Use this procedure to delete a schema-level backup.

Procedure

  1. Retrieve information about the backup that is to be deleted: 
    db_backup -history
  2. Note the location (backup path) and timestamp of the backup.
  3. Remove the backup: 
    rm -rf location/timestamp
  4. Delete the backup entry from the history: 
    db2 "delete from IBM_SAILFISH.GRANULAR_BACKUP where TIMESTAMP = 'timestamp'"