Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015
    Posts
    6

    Unanswered: Stop HADR for offline reorg

    Hi,

    I'm going to do offline reorg on some large tables(20 million records) on primary DB (10.5 on linux), secondary DB configured to be sync by by Async mode.
    Should I stop HADR before running offline reorg?
    I'm concern that generated logs during reorg causing secondary db huge gap log.

    Cheers,
    Daniel

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    20 million records is not a huge table unless you have a large rowsize and/or inline lobs etc. Have you read this?
    http://www-01.ibm.com/support/knowle.../c0024860.html

    We regularly run parallel reorgs on tables with 100 million+ rows and have not had a log space issue.
    What are the log parameters? logprimary, logsecond, logfilsiz
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

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