Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Performance: backup parameters

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by grofaty
    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.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi J Petruk,

    Thanks a lot.

    Thanks,
    Grofaty

Posting Permissions

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