Start of change

STATCLUS in macro DSN6SPRM

Specifies the type of clustering statistics that are to be collected by the RUNSTATS utility. Valid values are ENHANCED and STANDARD.

The default value is ENHANCED. The ENHANCED clustering statistics result in an improved CLUSTERRATIO formula and the statistic DATAREPEATFACTOR. These statistics allow improved SQL access paths based on improved recognition of the number of getpages that are required to retrieve the qualified rows and whether those getpages benefit from prefetch.

Recommendation: Use the default value of ENHANCED unless directed otherwise by IBM®.

This subsystem parameter is deprecated in DB2® 10.

End of change