BMC AMI Stats parameters (STTPARMS DD)

Each BMC AMI Utility has a set of product-specific parameters that let you control how the product processes and uses resources. For BMC AMI Utilities, you can include any of these parameters in your DD statement in your utility job stream to override the configured values. You can change the settings for these parameters at any time.

Also available are global parameters, specified in the UTLPARMS DD, that apply to all BMC AMI Utilities. STTPARMS DD for BMC AMI Stats are also used as global statistics parameters for all BMC AMI Utilities that gather, report, and update statistics.

Installing a BMC AMI Utility configures the defaults for the global parameters, separately for each IBM Db2 subsystem. Each job can then override these default global parameters, if needed. The job output of each BMC AMI Utility lists the default parameters and any overrides.

Related topics

DD statements for BMC AMI Stats
Command and syntax reference for BMC AMI Stats


Important

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

BMC AMI Stats parameters (STTPARMS) in alphabetical order

Parameter

Use and value

Specifies how many column values are collected for statistics

Specifies which frequency column values to collect

Specifies whether to write and what type of statistics to write to the Db2 Catalog history tables

Specifies the number of concatenated index columns for which you want to collect frequency statistics

Specifies whether to print the BMC AMI Stats report to RUNSTATS DD

Specifies whether to read table spaces during statistics collection

Specifies whether to roll up statistics when statistics are gathered for a subset of the partitions. The Db2 catalog tables that contain values for the entire table space are updated to correctly reflect the RTS and partition subset values.

Specifies what statistics to write to the Db2 catalog


 

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