Db2

 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

    Hello,

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



    ------------------------------
    Mark Barinstein
    ------------------------------

    Original Message


  • 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

    Cheers



    ------------------------------
    Roland Schock
    IBM Champion and IBM Gold Consultant
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message