DB2 database backup

Question

I currently have a 200+ GB database that uses the built-in DB2 backup for daily backups (and hopefully does not restore - lol). But since this backup takes more than 2.5 hours, I am completing a third-party review of Backup and Restore. Version 8.2 FP 14 But I will soon move on to 9.1, and I also have 9.5 databases for backup and recovery. What are the best tools you have used for this purpose?

Thank!

Answer 1

One thing that will help is to upgrade to DB2 version 9 and enable compression. Then the backup size will decrease (up to 70-80% at the table level), which should reduce the backup time. Of course, if your database is constantly expanding, you will again encounter problems, but then you may need to archive data.

Answer 2

Before looking at third-party tools that I doubt would help a lot, I would consider a few optimizations.

1) Do you use REORG for your tables and indexes? This will reduce information and minimize the number of pages used;

2) If you can, backup to multiple drives at once. This can be easily achieved by runningdb2 backup db mydb /mnt/disk1 /mnt/disk2 /mnt/disk3 ...

3) DB2 , WITH num_buffers BUFFERS, BUFFER buffer-size PARALLELISM n. , DB2 :

4) ;

5) UTIL_IMPACT_PRIORITY UTIL_IMPACT_LIM , . , , datasever ;

6) DB2 9 , , . , 9.1 , , 9.5.

Answer 3

, - : 1. / 2.

, , , . , , ( ) . " " DB2. , REORG, Antonio. , , , , . DB2 . , DB2 Express-C . , 200 , , DB2 Express-C, .

openign , , . (, ). -, DB2 . , , , , . , DB2 .

Answer 4

Try High Performance Unload (HPU) - Infotel, Optim, https://www.ibm.com/developerworks/mydeveloperworks/blogs/idm/date/200910?lang=en

Answer 5

"" , , - DB2, Tivoli Storage Manager .

TSM, "" .

IBM, , DB2, .

IBM.:) , ($) .

Answer 6

, . , TSM , .

, , : , ? : ., , .

, .

( , - , .)

Answer 7

, , . , 2 , , .

, . , ? - ? , , , , RAID 5 , .

Naturally, you should make full backups sooner or later, but I hope you can find a window when the load is light, and you can live with a longer period of time between backups. Make your full backup over a 4-6 hour period when normal increments are disabled, and then make the incremental values ​​coming from it the rest of the time.

In addition, until you copy the backup to a completely separate system, you really are not backed up. You will have to experiment to find out if you are better off compressing it before, during, or after sending.