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.

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.

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


Related topics

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


 

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