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.

+UPDATE

The +UPDATE parameter specifies what statistic to write to the Db2 catalog. This parameter sets the UPDATE value for BMC AMI Stats as well as other utilities that update statistics.

BMC AMI Stats can write access-path statistics, space-related statistics, both kinds of statistics, or none. In the BMC AMI Utilities configuration, you can set +UPDATE to act as a user-specified default for all statistics jobs. The BMC configured default value is ALL. You can override +UPDATE by specifying UPDATE in the SYSIN DD statement. 

Specify one of the following values for value.

UPDATE.png

value

Specify one of the following values for value:


Value

Description

ALL or A

(SPE2010

) (Default) Writes access path and space statistics to the Db2 catalog

NONE or N

Does not write any statistics to the Db2 catalog

PATH or P

Writes only access-path statistics to the Db2 catalog

SPACE or S

Writes only space-related statistics to the Db2 catalog

For an example of this parameter, see Using BMC AMI Stats.

Success

Tip

You can use the UPDATE option in the SYSIN statement to set this value.

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