Hi,

For offline backup-ing the database I use the following command:
BACKUP DATABASE sample USER user USING password TO c:\backup WITH 3 BUFFERS BUFFER 1024 WITHOUT PROMPTING

What is the optimal performance value for:
1. number of BUFFERS and
2. BUFFER size?

This database is datawarehouse database and I have 2 GB of RAM. When executing the backup there are no processes running concurently. The main goal is minimal backup time.

My system:
DB2 V7.2 fp5 on Windows 2000 SP3

Thanks,
Grofaty

Number of buffers - my understanding is that increasing this is only an advantage when you're backing up to more than one directory.

Buffer size - bigger is better.

Parallelism is your biggest bang for the buck, it lets db2 read from multiple tablespaces at the same time.

See the Data Recovery and HA Guide, though, it has a lot more detail.

Hi J Petruk,

Thanks a lot.

Thanks,
Grofaty