Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    7

    Unanswered: reduce offline backup time in DB2V7.1

    hello everybody
    when i perform db2 offline backup by command
    db2 backup database pathlab user db2inst1 using ibmdb2 to /usr/backup
    or
    db2 backup database pathalb user db2inst1 using ibmdb2 to /usr/backup with 6 buffers buffer 129 parallelism 2


    but both command took half an hour which is to much for just 20 tables with 15 days data???
    can i reduce this backup time by any way????
    please help

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    Hi shefallid,

    Here are some "generic" suggestions:

    Try altering the number of buffers up/down to see if the performance increases/decreases.

    Try using different disk locations for your backup file to reduce head contention.

    Try compressing your database before backup to reduce disk access time.

    Check your DB2 statistics on the tables in question and make sure the tables are running efficiently.

    Good Luck,
    Bruce Baasch

  3. #3
    Join Date
    Jul 2002
    Posts
    86
    Originally posted by Bruce A. Baasch
    Hi shefallid,

    Here are some "generic" suggestions:

    Try altering the number of buffers up/down to see if the performance increases/decreases.

    Try using different disk locations for your backup file to reduce head contention.

    Try compressing your database before backup to reduce disk access time.

    Check your DB2 statistics on the tables in question and make sure the tables are running efficiently.

    Good Luck,
    could you please let us know what you mean "compress the database" and how?
    thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    7
    Originally posted by Bruce A. Baasch
    Hi shefallid,

    Here are some "generic" suggestions:

    Try altering the number of buffers up/down to see if the performance increases/decreases.

    Try using different disk locations for your backup file to reduce head contention.

    Try compressing your database before backup to reduce disk access time.

    Check your DB2 statistics on the tables in question and make sure the tables are running efficiently.

    Good Luck,

    hello,sir if we take backup in two different disk location then while restore again we will have to mention those two locations in same order???

    Also how to compress the database contenets and then take the backup??

    please tell

Posting Permissions

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