Implementation of DB2 partitioned Database Backup

The backup method of the DB2 partitioned database is different from that of the general backup method. The following describes how to implement the backup method of the DB2 partitioned database.

Backup operations on the DB2 partitioned database:

The backup operation only applies to the current partition of the partitioned database. Therefore, you must use the "db2_all" command to back up all partitions. Here, the online backup mode is used. That is:

Db2_all "db2 backup db sample online"

However, the preceding commands are used in serial mode for backup of each partition. To improve the performance of backup operations, there is also a method that enables Parallel intervals. That is to say, add the following option before the DB2 command of the preceding command to achieve parallel command:

<+ Partition Number <: indicates that subsequent commands act on the partition.
<-Partition Number <: indicates that subsequent commands act on partitions other than this partition.
| <-Partition Number <or <-Partition Number;: indicates that subsequent commands are used to recover data from other partitions except the partition, and are performed in parallel.

However, backup and recovery operations require exclusive partitioning. Therefore, before performing parallel backup operations on other partitions, you must complete backup operations on the partition. The method is as follows:

Db2_all "<+ 0 <db2 backup db sample online" -- backup of cataloguing partitions
Db2_all "| <-0 <db2 backup db sample online" -- Parallel backup of hard disk data recovery in other partitions
Or db2_all "<-0 <; db2 backup db sample online"

Note: After the backup of the partitioned database is complete, a backup image file is generated for each partition.

Three types of DB2 database backup solutions

Online Implementation of changing the DB2 page size

Create a DB2 tablespace in windows

Take you to the DB2 Character Set and MySql Character Set

Use of the DB2 auto-incrementing field IDENTITY