Backing up, restoring, and recovering databases

You can use PATROL for DB2 UDB to perform maintenance and recovery procedures on your DB2 databases. You can perform the backup and restore procedures from the DB2 instance icon menu. Use the Rollforward and History commands to help you recover a database. You can also recover a database that has terminated by using commands available in the database icon menu.

To back up, restore, and recover DB2 databases

1. Right-click on the DB2 DBM instance icon and select Database Administration > Database Mgmt.
2. Use the following commands to complete your task:
   • Backup Database
   • Schedule Backup (available only in UNIX)
   • Restore Database
   • Rollforward Database
   • Display History File
   • Prune History File

Notes about backing up a database

Backing up a database requires you to select a backup method. Ensure that the location that you specify in the backup method has enough available space to accommodate the backed up database so that the command can complete successfully.

Also, ensure that the database is not in use. The KM will detect that the database is in use under the following circumstances:

• An SQL Viewer is active.
• Deadlock detection is enabled.

To recover a DB2 database that has terminated

1. Right-click on the DB2 database icon and select Database Administration > Recovery Mgmt.
2. select the following commands to restart the database and to process any indoubt transactions that might be pending:
   • Restart Database
   • Process Indoubt Transactions
3. If indoubt transactions exist, you can select the transaction and process the transaction using one of the following options: