Transactions are running without statistics during table switch (4327973)

If the option "Restore original statistics in data dictionary for Cost Based Optimizer" in the Analyze tab is checked, the updateobjectstats function will run after the table switch. However if there are some transactions on the table before the updateobjectstats function has completed running, then these transactions will run without any statistics. That could mean that the transactions will run with the wrong execution plan on some occasions.

Here an example:

1. Copy table and create index on copy table

2. Switch from original table to copy table
...
EXECUTE QUEST_EXEC.ONLINE_SWITCH
...
EXECUTE QUEST_EXEC.ONLINE_COMPLETE
...
EXECUTE QUEST_EXEC.LW_FINISH_REORG
...

3. Some transactions are occurring at this time

4. Restore original statistics on copy table
quest_spc_analyze.UpdateObjectStats

5. All jobs are completed

The transactions in step 3 will run without statistics.

WORKAROUND

Reduce activity on the table  during the switch.

STATUS

Enhancement request ST61462 has been submitted to Development for consideration in a future release of Space Manager with LiveReorg.

Enhancement Request ST61462 to move the restore statistics step to before the switch.