STATISTICS ROLLUP field (STATROLL subsystem parameter)
The STATROLL subsystem parameter specifies whether the RUNSTATS utility is to aggregate the partition-level statistics, even though some parts might not contain data.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 34 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM STATROLL |
For Db2 subsystems that have large partitioned table spaces and indexes, it is recommended that you specify YES for STATISTICS ROLLUP. Specifying YES for STATISTICS ROLLUP enables the aggregation of partition-level statistics and helps the optimizer to choose a better access path.