In the Object Explorer, when generating a script for runstats on a tablespace, the statements created use 'TABLE (ALL) SAMPLE 25'. Is there a way to have them created with 'TABLE (ALL)' and not include 'SAMPLE'?
The script for the runstats is being created by right clicking on a tablespace in the Object Explorer, selecting Utilities | Runstats, and clicking the “Show Script” button.
Existing Code:
RUNSTATS TABLESPACE DAAS01.SAASAP
TABLE (ALL) SAMPLE 25
INDEX (ALL)
SHRLEVEL REFERENCE
REPORT NO
UPDATE ALL
HISTORY NONE;
Required Code:
RUNSTATS TABLESPACE DSNDB04.ADAMTS2B
TABLE (ALL)
INDEX (ALL)
SHRLEVEL REFERENCE
REPORT NO
UPDATE ALL
HISTORY NONE;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center