Skip to Content

Onlie Reorg db2 without breaking HADR?

Hi All,

Thanks in advance.

Is it wise to do online reorg OS - DB level without Breaking HADR , Will it create any impact in Standby Server?

If we did Online reorg in Primary Server how to revert back.

Application Versions:

SAP level: 7.40

Db: db2 LUW 9.7

OS: HP-Unix

Regards,

Mithran

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 06 at 03:46 PM

    Hi Mithran,

    are you talking about INPLACE REORG? Why do you want to do REORG?

    I believe note 1942183 is a nice overview note. RECLAIM REORGs should be done also in a HADR cluster. Other REORGs I would only perform if neccessary and not in a regular manner.

    If a non reclaim REORG can not be avoided I would also think about using ADMIN_MOVE_TABLE via DB6CONV instaead of using a traditional DB2 REORG.

    Regards

    Frank

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2017 at 09:33 AM

    Hi Mithran,

    As far as I know, HADR (secondary site) may have performance issue based on fragmentation. The relay part can run longer/performance issue at DR site.

    You need or may require to tune in some parameters to avoid this.

    Please go through below link that should help you choosing the type or reorg (offline/online) and all that.

    goo.gl/D14oK3

    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded