BMC AMI Load +RUNSTATS

The UPDATEDB2STATS option overrides the +RUNSTATS parameter.

  • BMC AMI Load does not gather RUNSTATS during LOAD RESUME YES processing.
  • BMC AMI Load skips non-indexed tables.
  • The statistics that BMC AMI Load gathers update SYSCOLUMNS for the first column only of each index. Run BMC AMI Stats to obtain statistics for all columns of all indexes.

Related topic

BMC-AMI-Load-parameters-LODPARMS-DD

RUNSTATS_PTF_BQU1066.png

NO

(Default) BMC AMI Load does not update the statistics.

YES

BMC AMI Load updates the statistics according to the STTPARMS. The STTPARMS DD is the location in which the parameters for BMC AMI Stats for Db2 are specified. For more information, see Overview of BMC AMI Stats.

ALL

Same as YES

BMC AMI Load updates all statistics, including the history tables.

Additional considerations

The following additional considerations apply to the +RUNSTATS parameter:

  • BMC AMI Load updates column statistics for every column of every index.
  • You can also have BMC AMI Load collect frequency distributed statistics can also be collected. The BMC AMI Stats parameters (from the STTPARMS DD) control frequency statistics collection. If the STTPARMS DD does not supply these parameters for the load job, BMC AMI Load obtains them from the BMC AMI Utilities configuration.
  • For partitioned table spaces, BMC AMI Load does not update table statistics unless there is an index on the partitioning columns or a DPSI defined.

  • For a list of which Db2 catalog statistics you can update, see Overview of BMC AMI Stats.

Example
+RUNSTATS(YES)

BMC AMI Load gathers statistics and updates the Db2 catalog with the new values.

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*