Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: reorg clean up options

    Db2 V 9.7

    Having HADR set were DR is enabled for read access DB2_HADR_ROS = yes

    Have a partition table which is having huge delete indexes keys

    Need to execute reorg for clean up

    reorg indexes all for table tabschema.tabname allow write access cleanup only ;

    Will this effect my DR database, as user access it 24/7. Will HADR will go into replay mode.



    regds
    Paul

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    According to the documentation reorg indexes triggers a replay-only window on standby.
    Replay-only window on the active standby database
    Regards,
    Mark.

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    Hi Mark,

    Yes any reorg in priamry makes standy in replay-only window.

    regds
    Paul

Posting Permissions

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