What preparations should be made before DB2 database backup?

This article mainly introduces the preparation description before the DB2 database backup, including the factors for setting the database to be restored, the preparations before the DB2 backup and before the DB2 recovery, the following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

DB2 Recovery Type

1. Crash recovery: Roll Back uncommitted transactions to prevent database inconsistencies

2. Version recovery: Use the Backup command to obtain the Backup image for restoration.

3. roll-forward recovery: Restore with Rollforward by using full database backup

Factors for database recovery:

1. If the database is only used for query and there is no working transaction unit in the log, there is no need for the database to be set to recoverable;

2. If the data of the database is stable or has few changes, and the data can be easily rebuilt, there is no need for the database to be set as a recoverable database;

3. databases that contain data that is not easy to reconstruct should be configured as recoverable databases;

4. If there is a large amount of data updates, consider using a recoverable database;

Prepare for DB2 backup

1. You must have SYSADM, SYSCTRL, or SYSMAINT permissions to perform backup;

2. The database can be a local database or a remote database, and its backup is stored on the database server;

3. The BAKCKUP command can be used to manage backups directly with the plug-in memory management program, such as ADSM;

4. The BAKCKUP command can directly transmit its output to the disk through the OS/2 of the operating system;

5. The BAKCKUP command can directly transmit its output to the hard disk for backup on any platform;

6. You can create multiple backup files to include the backed up data.

Preparations before DB2 recovery

1. You must have SYSADM, SYSCTRL, or SYSMAINT permissions to recover data. If you have SYSADM and SYSCTRL permissions, you can recover data to a new data;

2. Only the RESTORE command can be used for databases that have been backed up using the BACKUP command;

3. The RESTORE command can be connected to external memory;

4. The RESTORE requires exclusive connection to the database. When the database is being recovered, other programs cannot run on the database. Once it starts running, it will prevent other programs from accessing the current database until the recovery is complete;

5. The database can be a local database or a remote database.

The above content describes the preparations before the DB2 database is backed up. I hope it will help you in this regard.