Not able to create the following runstats statement on multiple tablespaces. Forced to work on each tablespace individually to create the runstat statement.
RUNSTATS TABLESPACE SCHEMA1.TSXXA INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXD INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXH INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXI INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXL INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXN INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXP INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXS INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSXXT INDEX(ALL)
RUNSTATS TABLESPACE SCHEMA1.TSYYB INDEX(ALL)
WORKAROUND:
1. Select multiple tablespaces in Object Explorer and right-click | reorg.
2. In Reorg window, select Index Statistics tab to open it.
3. From top grid, click on each tablespace name to refresh Index Statistics tab.
4. Generate script to see the INDEX (ALL) in all statements.
NOTE: The workaround is not ideal for large number of tablespaces.
STATUS:
Enhancement request number TDB-431 has been submitted to Development for consideration in a future release of Toad for DB2 to better handle multiple-select scenarios.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center