Several options are available for enhancing backup performance and reduce the network bandwidth used for performing backups. These options include:
-
Specifying the number of buffers for the backups. When you are backing up the database to multiple locations, you can specify a sufficient buffer value to improve performance.
-
Specifying the size of the buffer
-
Setting the parallelism.
DB2 Agent perform backups use a system-generated script that is run behind the scenes from a command line. The CommCell Console serves as a front-end user interface for specifying various arguments and parameters that are passed to the backup script that is run.
Procedure
-
From the CommCell Browser, expand Client Computers > client > DB2 > Instance > backup_set.
-
Right-click the subclient, point to All Tasks and then click Create Subclient.
The Subclient Properties dialog box appears.
-
On the Advanced Options tab :
-
In the Number of Buffers box, type or select the number of buffers.
The default value is 2. However, if you are backing up to multiple locations, use a sufficient number of buffers to improve performance, and to avoid potential backup failure.
-
In the Buffer Size box, type or select the buffer Size.
The minimum value is 8, and the default value is 1024.
-
In the Parallelism box, type or select the number of Parallelism queries you want to set for your backup operation.
If the number is not set, the optimal value will be chosen automatically.
-
-
Click OK.