Avoiding Inoperative Tables on the HADR Standby

You may also like...

9 Responses

  1. Michael Roecken says:

    Hi. As of 10.5FP9 and 11.1.2.2 Db2 has introduced two new features that some customers may find interesting to help with table spaces going unavailable on the standby:

    1. Monitoring and identifying table spaces in invalid or error state, or tables in Inoperative state on the HADR Standby database

    A new flag in STANDBY_TABLESPACE_ERROR was added to the HADR_FLAGS field of db2pd -hadr (or the MON_GET_HADR() table function).
    For more details about monitoring this error condition, please see:
    https://www-01.ibm.com/support/docview.wss?uid=swg21993013

    2. How to recover from table space errors on an HADR Standby database

    A table space backup taken on the primary can now be restored on the standby. Yes, an offline table space restore can now be issued on the standby in order to repair a bad error state, while all along keeping the HADR role as a standby.
    For more details on how to recover from this condition using a table space backup image, please see:
    http://www-01.ibm.com/support/docview.wss?uid=swg21993389

    • Ember Crooks says:

      I read the documentation on this feature carefully, and thought it was just for tablespace errors – are they caused by inoperative tables?

  2. Anik says:

    Hi Ember,

    Recently in my PROD ENV , one of the table went to roll-forward pendin state on standby DB, i have 2 standby server,but this happened to only 1 standby which is connect through LAN with my primary DB. so if you could tell me what could be the reason for this and how can we prevent it further ? Because the only option left for me to recover was Restore or re-initialize tablespace which was again very lenghty process. so any input on this would be helpful 🙂

  3. IsaacMunoz says:

    Hi Ember, thanks for the post. Your RFE link is broken… can’t access it.
    Regards

    • Ember Crooks says:

      It works for me in both Chrome and firefox. RFE links have major problems with them in some scenarios. If you log in with your IBM ID first, then it is more likely to work.

  4. Wayne says:

    Quoted from the TechNote,

    3. A TRUNCATE operation is performed on the table on the Primary database.
    4. An IMPORT operation with the REPLACE option is performed on the table on the Primary database.

    What is the best practice to deal with them in HADR environment?
    Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *