What do I need before backing up a DB2 database?

The following articles mainly describe what preparations should be made before DB2 database backup is implemented. The following describes how to prepare DB2 database backup before implementation, what preparations do we need to provide? I hope you will have a better understanding after browsing.

Database

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: Use Rollforward for recovery by using full DB2 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 be used to back up the DB2 database on any platform to directly transmit its output to the hard disk;

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 is an introduction to the preparation before the DB2 database is backed up. I hope you will get something.