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.

Get DB2 Integrated Cluster Environment Deployment Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.