Mkae my Backup faster : )

itsonlyme44 · #1 (**permalink**) 05-27-09, 14:16

Running DB2 9.5 LUW I have a quad CPU 3 GHZ with 4GB of RAM.

Here is my backup code:

Code:

CONNECT TO PRODDM user db2admin using db2admin;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
SELECT current timestamp FROM sysibm.sysdummy1; 
CONNECT RESET;
BACKUP DATABASE PRODDM user db2admin using db2admin TO "\\kocudb01\Backups\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO PRODDM user db2admin using db2admin;
SELECT current timestamp FROM sysibm.sysdummy1;
CONNECT RESET;

takes about 90 mins to back up 80GB (to the same box)

Can anyone help me tweek my code to make the backup run faster ? ? (ie..more buffer, bigger buffer etc... )

db2girl · #2 (**permalink**) 05-27-09, 15:30

Please see the following:
DB2 Backup with TSM Optimization

Use multiple target devices if possible (ie. network drives). Target devices are almost always the bottleneck. The more target devices, the faster backup will go.

itsonlyme44 · #3 (**permalink**) 05-27-09, 15:32

Our current need is to backup to the local server where the backup is then written off to tape. no way to make it faster increasing buffers etc...?

db2girl · #4 (**permalink**) 05-27-09, 15:40

Please use the following general guidelines:
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Increase parallelism if you have multiple tablespaces. Specifying multiple targets (directories) on the local server should help. Please check the link for other parameters.

db2udbgirl · #5 (**permalink**) 05-27-09, 16:13

Bella, Is it a good idea to double the UTIL_HEAP_SZ and half the DBHEAP during backup to improve the performance ?

DB2 Manual doesn't recommend it but I read it in few other forums. Any thoughts on this ?

Marcus_A · #6 (**permalink**) 05-27-09, 16:16

IN 9.5 DBHEAP and UTIL_HEAP_SZ should be set to automatic.

Internet Services

Web Development

Digital Marketing

Consumer Tech