View Only
  • 1.  Auto Reorg

    Posted Wed October 25, 2023 11:35 AM

    Hello, hoping someone might be able to help my understanding of having a database configured with AUTO_REORG = ON.

    We have a database configured with Auto Reorg = to ON and I can see in the log that the reorg evaluation is occurring but I never have seen an actual reorg occur.  Am I missing a step for DB2 to automatically reorg my tables?

    I run the list history command for reorg on the database and find zero entries. 

    Wayne VanNewkirk

  • 2.  RE: Auto Reorg

    Posted Wed October 25, 2023 02:17 PM


    Only offline (classic) automatic table reorg is possible.
    Have you defined an offline maintenance window to run these reorgs?

    Mark Barinstein

  • 3.  RE: Auto Reorg

    IBM Champion
    Posted Thu October 26, 2023 01:52 AM

    Hi Wayne, 

    as @markbarinstein already mentioned, you need a reorg policy to define a time frame within that the reorg is allowed.

    Have a look here https://www.ibm.com/docs/en/db2/11.5?topic=sertis-scenario-examplebank-reclaiming-table-index-space-auto-reorg-policy


    Roland Schock
    IBM Champion and IBM Gold Consultant

  • 4.  RE: Auto Reorg

    Posted Fri October 27, 2023 01:17 PM

    Thanks to both of you.  Not as Auto as I had hoped.  Reading up getting a bit nervous on understanding the application impact to turning this on.

    Going to give it a try slowly:)

    Wayne VanNewkirk