User notices that the “Perform Sort Reorg” checkbox gets checked in the Customerize Object Allocation window when he does not have this same option checked in the previous Choose Scripting Options window? User is concerned what impact will there be if he was to uncheck this option. Will unchecking this option affect the integrity of the data and structure of the tables once reorg is complete?
According to CR 78663, sometimes Space Manager will check this option for some objects in the reorg even though the user has not selected it at the global level. This CR has been escalated by development.
Use the “Back” button to move back to the Scripting Options screen where the option is set at the global level, and check it/uncheck it. This should fix it for all the tables in the reorg.
User can also open the reorg script and do a search for the string "order by" to see which tables will have a "sorted reorg".