Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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.

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.

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

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*