IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
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.
Hello,Only offline (classic) automatic table reorg is possible.Have you defined an offline maintenance window to run these reorgs?
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
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:)