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 Stats for Db2 13.1.

+NUMCOLS

The +NUMCOLS parameter specifies the number of concatenated index columns for which you want to collect frequency statistics. This parameter is only used for BMC AMI Stats.

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

NUMCOLS.png

1

(SPE2010) (Default) Collects frequency values for 1 concatenated column.

numberIndexColumns

Specifies the number of concatenated index columns for which you want to collect statistics. Valid values are 1 through 16.

Information
Example

+NUMCOLS(10) collects frequency values for up to 10 concatenated columns. If a table has only three columns, BMC AMI Stats will collect frequency statistics for those three columns.

Success

Tip

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

KEYCARD FREQVAL NUMCOLS 10 COUNT numberValues MOST

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 Stats for Db2 12.1