Shulou(Shulou.com)05/31 Report--

Editor to share with you how to improve the performance of DB2 database backup operations, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Increase the size of the database configuration parameter UTIL_HEAP_SZ, an area of memory used to provide buffering for backup and restore operations. The following is an editor to explain how DB2 databases improve the performance of backup operations and how DB2 databases improve the performance of export operations (export).

How to improve the performance of backup operation in DB2 database

Increase the size of the database configuration parameter UTIL_HEAP_SZ, an area of memory used to provide buffering for backup and restore operations.

Reduce the backup of the whole database and use more tablespaces needed for tablespace backup.

Reduce full backup and use incremental backup or DELTA backup more.

Add the PARALLELISM parameter in the backup command to increase the parallelism of the backup (increase threads or processes).

Increase the BUFFER parameter value in the backup command.

Increase the target directory of the backup, and it is best to put multiple directories on different hard drives, which can increase the degree of parallelism of the backup.

Let's take a look at how to improve the performance of restore operations:

As with backup operations, you need to increase the size of the database configuration parameter UTIL_HEAP_SZ.

Increase the BUFFERS parameter value in the restore command.

Add the PARALLELISM parameter in the restore command to increase the parallelism of the backup (increase threads or processes).

Containers distributed on different hard drives can also speed up recovery operations (improve parallelism).

SMP mode is used to activate multi-agents to increase the parallelism of recovery operations.

How to improve the performance of Import Operation (import)

The import operation is similar to the insert operation, so there are many ways to see the tuning steps of insert.

Adding the compound=x option allows the import operation to be carried out in batches and reduces network traffic.

Increasing the value of COMMITCOUNT has reduced the number of LOG's.

Enable buffer insertion and rebind to the database using the INSERT BUF option for the db2uimpm package. Execute the command before import: db2 bind db2uimpm.bnd insert buf

How to improve the performance of export operation (export)

The Export operation is similar to the select operation, so there are many ways to see the tuning steps of select.

Put the files exported by the export operation on a hard disk that is different from the data and logs to reduce the competition of Imax O.

Improve the performance of the load operation (load): there are fewer log writes in load than in import, so the performance of load is much better than import, so let's see how to better improve the performance of load.

In a multi-partition environment, db2 load will be loaded in parallel, and the performance will be greatly improved.

Adding the buffer parameter increases the cache space during the load process and improves performance.

These are all the contents of the article "how to improve the performance of backup operations in DB2 databases". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.