PAGE-LEVEL SAMPLING field (STATPGSAMP subsystem parameter)
The STATPGSAMP subsystem parameter specifies whether the RUNSTATS utility uses page-level sampling by default for universal table spaces (UTS).
STATPGSAMP applies only for UTS, and has no effect on other table space types.
Also, STATPGSAMP applies only when the TABLE option is specified in the RUNSTATS statement.
| Acceptable values: | YES, NO, SYSTEM |
|---|---|
| Default: | SYSTEM |
| Update: | option 34 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM STATPGSAMP |
| Data sharing scope: | Member |
| Online changeable: | Yes |
- SYSTEM
- Db2 determines the default sampling method for statistics collection.FL 505 SYSTEM has the same meaning as YES.
- YES
- The utility always executes as if the TABLESAMPLE SYSTEM AUTO utility option is specified. (TABLESAMPLE SYSTEM AUTO specifies that the utility uses page sampling, and determines the sampling rate.)
If the RUNSTATS statement contains TABLESAMPLE SYSTEM and a value other than AUTO, RUNSTATS uses that value instead of AUTO.
If the utility statement specifies SAMPLE to request row sampling, Db2 ignores that option and uses page sampling instead.
- NO
- The utility does not use page sampling by default. Any sampling is determined by the options that are specified in the utility statement.