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.

+COUNT

The +COUNT parameter specifies how many column values are collected for statistics. This parameter is only used for BMC AMI Stats.

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

COUNT.png

numberColumnValues

Specifies the number of column values collected. Specify any value from 1 through 100.

Information
Example

+COUNT(10) tells BMC AMI Stats to gather statistics for 10 values in each column.

10

(SPE2010) This is the BMC configured default value.

Success

Tip

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

KEYCARD FREQVAL NUMCOLS numberColumns COUNT 9 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