STATROLL—Aggregate partition statistics
Use the Aggregate Partition Statistics panel or the STATROLL command to specify whether the RUNSTATS utility will aggregate partition-level statistics. Enabling the aggregation of partition-level statistics can help the Db2 optimizer choose better access paths.
Modify Aggregate Partition Statistics panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : AGGREGATE PARTITION STATISTICS
Type the new Aggregate Partition Stats Indicator you wish to change to. Then press Enter.
Enable Partition Statistics Aggregation
Enable Stats Aggregation . . (Y, N)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
Y | The RUNSTATS utility will aggregate partition-level statistics. |
N | The RUNSTATS utility will not aggregate partition-level statistics. This is the Db2 default. |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Enable Stats Aggregation | DSNTIPO | SPRMSTRL | DSN6SPRM | STATROLL |