Skip to Content

Want to set Delay in Archive log apply at DR site

Hi Experts,

Is there a way to keep delay in applying logs at DR site in DB2 9.1 Fix pack 7.

I noticed that this option is available only after DB2 9.7 fix pack 5 and above using SUPERSYNCH sync

mode. But our client does not want to upgrade the DB right now.

Please suggest me with your valuable info.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 16, 2014 at 06:23 AM


    In DB2 9.1 HADR configuration, only 3 modes are available- SYNC, NEARSYNC and ASYNC. If you want to delay it then you should use ASYNC mode.



    Add a comment
    10|10000 characters needed characters exceeded

    • Sunny,

      I already referred to documents and links that you suggested me, also referred db2 admin

      guide and searched for information over internet but i didn't found any information related to SAP

      level activities after initial switch over.

      As per my knowledge we need to apply license, import SAP profiles of DR server and TMS

      configuration is required. Apart from these any thing else need to do?

      Please suggest me with any guide or link where these activities are mentioned.



  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 03:56 PM

    Hi Bharath,

    if you want to facilitate this with your database, I would recommend you to use Libelle Business Shadow or just DBShadow.

    Especially if you want to have reliable and fast disaster recovery. Up from DB2/DB6 10.1 time leaps are possible for additional cluster nodes in HADR.

    Best regards,


    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.