Changing backup expiration settings

Deployment options: IBM Netezza Appliance

About this task

When you perform a full backup of a database to IBM® Spectrum Protect (formerly Tivoli® Storage Manager) by using nzbackup, any previous backups of that database are marked as inactive. The Tivoli Storage Manager server configuration settings specify how it manages inactive files. The Tivoli Storage Manager default is to make all inactive files immediately unavailable. If you want the ability to restore from backup sets other than the most recent, review and adjust the Tivoli Storage Manager configuration setting for Number of days to keep inactive versions. The default is zero, which means that only the latest backup set is available for use in restores.

To change the backup expiration setting, complete the following steps.

Procedure

  1. In the left navigation frame of the ISC Console, click Tivoli Storage Manager.
  2. Click Policy Domains and Client Nodes. In Tivoli Storage Manager 6, this menu is Policy Domains.
  3. Select the Tivoli Storage Manager server from which you will be managing your Netezza Performance Server systems.
  4. Select the policy domain which has the Netezza Performance Server host machine as a client node.
  5. In the Properties section, select the Management Class which governs the Netezza Performance Server host client node.
  6. In the left pane of the Class Properties page, select Backup settings.
  7. Review the Number of days to keep inactive versions field to specify how long you want to keep inactive (that is, older than the latest) backup sets.

    Set this value to a positive number to keep and use inactive backup sets for that period of days. For more information about the range of values and possible impacts to the Tivoli Storage Manager server, see the Tivoli Storage Manager documentation.