This topic describes the common options syntax for BMC AMI Stats.
1 This option is available only if you have applied PTF BQU0592.
2 This option is available only if you have applied PTF BQU1066.
| 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) (PTF BQU0592
applied) | 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.
|
|---|
| Indicates whether to update the Db2 catalog's history data Specify one of the following values for HISTORY: | |
|---|
| (SPE2010) (Default) Writes access-path statistics and space-related statistics | | Writes access-path statistics | | Writes space-related statistics | | Does not write statistics to the history tables |
WarningImportant (SPE2005) HISTORY overrides HISTORY parameter. If you specify +HISTORY(DFLT) and do not specify HISTORY, NGTSTATS uses the STATHIST DB2 DSNZPARM variable. |
|---|
INVALIDATECACHE (YES|NO) (PTF BQU0592 applied) | Tells BMC AMI Stats whether or not to clear the dynamic statement cache | |
|---|
| Clears the dynamic statement cache If you do not request data and reports, this is the default value.
| | Does not clear the dynamic statement cache If you request data and reports, this is the default value. |
|
|---|
READTS (PTF BQU1066 applied) | Tells BMC AMI Stats to read table space data during statistics collection to gather additional statistical information. | |
|---|
| (Default) Does not read table space during statistics collection WarningImportant Omitting READTS is equivalent to specifying READTS NO. | | Reads table spaces during statistics collection | | Reads table spaces during statistics collection (equivalent to specifying READTS YES) |
|
|---|
| Indicates whether to generate a report of the statistics collected Specify one of the following values for REPORT: | |
|---|
| Generates a report to the RUNSTATS DD | | Does not generate a report |
|
|---|
| Tells BMC AMI Stats whether to save the statistics in the BMC statistical repository database | |
|---|
| | | (Default) Does not save the statistics |
|
|---|
| Indicates whether to update the Db2 catalog with new statistics values Specify one of the following values for UPDATE: | |
|---|
| (Default) Updates access-path statistics and space-related statistics | | Updates only catalog tables that Db2 uses to determine SQL access paths | | Updates only space-related catalog statistics | | Does not update the catalog tables |
|
|---|
