Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: Mkae my Backup faster : )

    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... )

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Please see the following:
    http://www.dbforums.com/db2/1642889-...imization.html


    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.

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    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...?

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  5. #5
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103
    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 ?

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    IN 9.5 DBHEAP and UTIL_HEAP_SZ should be set to automatic.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •