DB2 Integrated Cluster Environment Deployment Guide

Chapter 5. Operations and administration 267

When all tasks run successfully you get the message shown in Figure 5-76. If

there was a problem you get a similar screen showing the error message. Shut

the window with the Close button.

Figure 5-76 Archival logging - Success message

5.1.3 Self-tuning for backup and restore

DB2 UDB V8.2 will now automatically choose the number of buffers, the buffer

size, and the parallelism settings for both backup and restore operations. The

values chosen are based on the amount of memory available, the number of

processors available, and the database configuration. The objective is to

minimize the amount of time required for backup and restore operations to

complete. The BACKUP DATABASE and RESTORE DATABASE commands

will automatically choose an optimal value for the following parameters whenever

they are not explicitly specified:

 WITH num-buffers BUFFERS

 PARALLELISM n

 BUFFER buffer-size

For restore database operations, a multiple of the buffer size used for the backup

operation will always be used.