Hi,

i've an OLTP-System were i don't get a Maintenance Window for Offline-Reorgs on the Database.
I'm not sure if it's worth to write a script to perform online reorgs on the table. In the script i'ld identify the table that needs reorgs (reorgchk) and start the reorgs for the table.
Isn't that just the same that the AUTO_REORG does?

There should be not too many Reorgs in parallel? Should be tricky to control that from a script, but i don't see any Options for AUTO_REORG. With the Policies it's easy to specify a period for the reorgs. Anything i missed?

What are your thoughts about this?

Cheers
nvk