runstats on a table partitions

#1

Hello Experts,

Is it possible to execute runstats only on a specific partition of a
partitioned table in the database? Looking for an equivalent of oracle
dbms_stats.gather_table_stats for a partition of partitioned table.

Thanks,
Puneet

#2

Hi Puneet,
try something like this (it's for DB2 on z/OS, but on LUW there will
something similar)

RUNSTATS TABLESPACE DSN8D91A.DSN8S91E PART 1 INDEX(DSN8910.XEMP1 PART 1)

http://publib.boulder.ibm.com/infoce...esrunstats.htm

hth
Kay

#3

On Apr 30, 2:44*am, Puneet <puneet... (AT) gmail (DOT) com> wrote:

Quote:

Hello Experts,

Is it possible to execute runstats only on a specific partition of a
partitioned table in the database? Looking for an equivalent of oracle
dbms_stats.gather_table_stats for a partition of partitioned table.

Thanks,
Puneet

No, DB2 LUW does not allow collecting statistics for a partition of
range partitioned table. You will need to collect table level
statistics instead.

Naresh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

runstats on a table partitions

comp.databases.ibm-db2 comp.databases.ibm-db2

runstats on a table partitions - 04-30-2010 , 04:44 AM

Re: runstats on a table partitions - 04-30-2010 , 08:21 AM

Re: runstats on a table partitions - 05-03-2010 , 10:57 AM