RUNSTATS on Partitioned Tablespaces

greenspun.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


Moderation questions? read the FAQ