Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Reorg for Db2 13.1.

+FREQ

The +FREQ parameter specifies which frequency column values to collect. This parameter is only used by BMC AMI Stats.

You can set +FREQ in the BMC AMI Utilities configuration to specify the default value for your installation. The BMC configured default value is MOST. You can override +FREQ by specifying FREQ in the SYSIN DD statement. 

Warning

Important

(PTF BQU2620 applied) For more information about how this default affects the frequency distribution collection and how to make NGTSTATS defaults match IBM RUNSTATS, see Overview of BMC AMI Stats.


Success

Tip

You can use FREQVAL in the syntax to override a +FREQ value specified in the BMC AMI Utilities configuration or in the STTPARMS DD:

KEYCARD FREQVAL NUMCOLS numberColumns COUNT numberValues MOST

FREQ.png

columnValue

Specifies which values to collect from a column based on frequency, as follows:

Value

Description

MOST or M

(SPE2010) (Default) Collects only the most frequent column values

LEAST or L

Collects only the least frequent column values

BOTH or B

Collects both the least and most frequent column values

NONE or N

Does not collect any frequency distribution statistics

Set NONE when you do not want to collect frequency statistics.

Warning

Important

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

Related topics

BMC-AMI-Stats-parameters-STTPARMS-DD
DD statements for BMC AMI Stats
SYSIN statement syntax
Command and syntax reference for BMC AMI Stats


 

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

BMC AMI Reorg for Db2 12.1