RUNSTATS on Partitioned Tablespacesgreenspun.com : LUSENET : DBAzine : One Thread |
When executing Runstats on a Partitoned tablespace with the PART parameter, can you use the INDEX(ALL) parameter as stated in Example-1:, or do you have to specify the implicit index-name and PART number as stated in Example-2:, or can you accomlish the same using Example-3.Example-1: RUNSTATS TABLESPACE DSN8D61.DSN8S61E PART 1 INDEX(ALL)
Example-2: RUNSTATS TABLESPACE DSN8D61.DSN8S61E PART 1 INDEX(DSN861.XEMP1 PART 1)
Example-3: RUNSTATS TABLESPACE DSN8D61.DSN8S61E INDEX(ALL)
Any clarification on this would be appreciated. Thanks. Ed. Majerczak
-- Edward Majerczak (edward_majerczak@nyce.net), January 31, 2002