Skip to Content

DB2 restore takes quite long time

Dear Experts,

We met a quite strange problem, DB2 restore for a 300GB database will take 40 hours to be finished...

We are running on DB2 9.7 FP10, database backup time is about 40 minutes (for offline backup) and 2.5 hours (for online backup with compress option), now we are restoring it to other servers, but the restore speed is quite unbearable, estimated to be finished in 2 days

We have tried both offline backup set and online backup set, and was on different servers, all will take 2 days...even slower than load based method.

Do you have any idea what's the root cause of it? I searched on the SCN but not satisfied answers...

Please help me out. Thank you very much.

Fresh

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 05, 2015 at 08:28 AM

    Hi,


    When you perform a restore operation, DB2 will automatically choose an
    optimal value for the number of buffers, the buffer size and the
    parallelism settings. The values will be based on the amount of utility
    heap memory available, the number of processors available and the
    database configuration. T
    Therefore, depending on the amount of storage
    available on your system, you should consider allocating more memory by
    increasing the UTIL_HEAP_SZ configuration parameter.

    Additionally, you can also choose to do any of the following to reduce
    the amount of time required to complete a restore operation:

    1, Increase the restore buffer size.
    The restore buffer size must be a positive integer multiple of the
    backup buffer size specified during the backup operation. If an
    incorrect buffer size is specified, the buffers allocated will be the
    smallest acceptable size.

    2, Increase the number of buffers.
    The value you specify must be a multiple of the number of pages that you
    specified for the backup buffer. The minimum number of pages is 8.

    3, Increase the value of the PARALLELISM parameter.
    This will increase the number of buffer manipulators (BM) that will be
    used to write to the database during the restore operation.

    you can find the best recommendations for backup / restore in the
    DBA guide for DB2 LUW.

    https://service.sap.com/~sapidb/011000358700001449002009E/

    db6_admin_guide


    Regards,
    Aidan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.