Skip to Content

+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.

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

UPDATE.png

value

Specify one of the following values for value:


Value

Description

ALL or A

(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.

 

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

BMC AMI Stats for Db2 13.1