PAGE-LEVEL SAMPLING field (STATPGSAMP subsystem parameter)

Start of changeThe STATPGSAMP subsystem parameter specifies whether the RUNSTATS utility or other utilities with inline statistics use page-level sampling by default for universal table spaces (UTS).End of change

STATPGSAMP applies only for UTS, and has no effect on other table space types.

Also, STATPGSAMP applies only for the following utilities:

  • RUNSTATS with the TABLE option.
  • Start of changeFL 500 REORG TABLESACE with the statistics option.End of change
  • Start of changeFL 500 LOAD with the STATISTICS option.End of change
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.

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.