+HISTORY

The +HISTORY parameter specifies whether to write and what type of statistics to write to the Db2 Catalog history tables. This parameter is used by BMC AMI Stats and all BMC AMI Utilities that update statistics.

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

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

HISTORY.png

value

Specify one of the following values for value:


Value

Description

ALL or A

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

NONE or N

Does not write statistics to the Db2 catalog history tables

PATH or P

Writes to the Db2 catalog history tables only the statistics that the Db2 optimizer uses

SPACE or S

Writes to the Db2 catalog history tables only space-related statistics

DFLT or D

Use the value from the DB2 ZPARM STATHIST parameter to control the HISTORY option.

Following are the values for DB2 ZPARM STATHIST:

  • NONE
  • ACCESPATH
  • SPACE
  • ALL

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

Important

  • A +HISTORY value is a PATH
  • An associated STATHIST value is an ACCESSPATH
  • NGTSTATS evaluates STATSHIST=ACCESSPATH as a PATH

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

Tip

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

  

 

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