Common options syntax

This topic describes the common options syntax for BMC AMI Stats.

Related topics

DELETEAGE (numberDays)

Tells BMC AMI Stats to delete statistics from the BMC statistical repository database if the statistics are older than the specified number of days

numberDays must be an integer from 0 through 32767:

0 deletes all statistics that were collected before the current BMC AMI Stats execution.
32767 turns off DELETAGE (meaning no statistics are deleted). This is the default value.

DELETEHISTAGE (numberDays)

Tells BMC AMI Stats to delete from the Db2 Catalog History tables those entries that are the specified number of days older than a value
specified in the STATSTIME column of each Db2 Catalog History table

numberDays must be an integer from 0 through 32767:

0 deletes all statistics that were collected before the current BMC AMI Stats execution.
32767 turns off DELETEHISTAGE (meaning no statistics are deleted). This is the default value.

HISTORY(value)

Indicates whether to update the Db2 catalog's history data

Specify one of the following values for HISTORY:

Value	Description
ALL	(Default) Writes access-path statistics and space-related statistics
ACCESSPATH	Writes access-path statistics
SPACE	Writes space-related statistics
NONE	Does not write statistics to the history tables

Important

HISTORY overrides HISTORY parameter. If you specify +HISTORY(DFLT) and do not specify HISTORY, NGTSTATS uses the STATHIST DB2 DSNZPARM variable.

INVALIDATECACHE (YES|NO)

Tells BMC AMI Stats whether or not to clear the dynamic statement cache

Value	Description
YES	Clears the dynamic statement cache If you do not request data and reports, this is the default value.
NO	Does not clear the dynamic statement cache If you request data and reports, this is the default value.

READTS

Tells BMC AMI Stats to read table space data during statistics collection to gather additional statistical information.

Value	Description
NO	(Default) Does not read table space during statistics collection Important Omitting READTS is equivalent to specifying READTS NO.
YES	Reads table spaces during statistics collection
No value	Reads table spaces during statistics collection (equivalent to specifying READTS YES)

REPORT (value)

Indicates whether to generate a report of the statistics collected

Specify one of the following values for REPORT:

Value	Description
YES	Generates a report to the RUNSTATS DD
NO	Does not generate a report

SAVESTATS(YES|NO)

Tells BMC AMI Stats whether to save the statistics in the BMC statistical repository database

Value	Description
YES	Saves the statistics
NO	(Default) Does not save the statistics

UPDATE (value)

Indicates whether to update the Db2 catalog with new statistics values

Specify one of the following values for UPDATE:

Value	Description
ALL	(Default) Updates access-path statistics and space-related statistics
ACCESSPATH	Updates only catalog tables that Db2 uses to determine SQL access paths
SPACE	Updates only space-related catalog statistics
NONE	Does not update the catalog tables

Common options syntax

On this page