Prev: Yellowfin 5.0 Webinar
Next: Yellowfin Launches 5.0
From: Puneet on 30 Apr 2010 05:44
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
From: Kay Kanekowski on 30 Apr 2010 09:21
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/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.ugref/db2z_samplesrunstats.htm

hth
Kay
From: Naresh Chainani on 3 May 2010 11:57
On Apr 30, 2:44 am, Puneet <puneet...(a)gmail.com> wrote:
> 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
 | 
Pages: 1
Prev: Yellowfin 5.0 Webinar
Next: Yellowfin Launches 5.0