Specifying What to Analyze options


These options specify what trigger analysis uses during the evaluation process.

These options answer questions such as whether System Trigger definitions should be used to determine the conditions to analyze. They indicate whether Db2 RTS data should be evaluated for specific exceptions. These options also give you the ability to suppress exceptions from evaluation based on categories such as REORG, STATISTICS, and COPY.

Specifying Analyze options

Specify these options as shown in the following table:

Option

Description

System Triggers

This option indicates whether to apply thresholds and corrective actions that are defined in the system.

If you specify SYSTEM TRIGGERS Y in the command syntax (or SYSTRIGS Y in the installation options module), BMCTRIG evaluates these exceptions in conjunction with system-level thresholds. Values that you specify on the BMCTRIG panels override values in the THRESHOLDS table for that exception. If you specify SYSTEM TRIGGERS N in the command syntax, BMCTRIG evaluates only thresholds that you specify on the BMCTRIG panels.

DB2 RTS

This option indicates whether to use the Db2 Real Time Statistics (RTS) for exception analysis. The choices follow:

  • Y - Use the RTS tables for exception evaluation in addition to the BMCSTATS statistics.
  • N - Do not use RTS tables.
  • O - Use the RTS tables for exception evaluation only.

If you specify Y, BMCTRIG accesses the RTS tables and uses those for exception evaluation in addition to the BMCSTATS statistics. If the same statistic is in both, BMCTRIG uses the RTS statistic value.

If you specify N, BMCTRIG does not evaluate RTS-based exceptions. If you specify N and also specify a DB2RTS exception, BMCTRIG cannot evaluate the exception.

If you specify O, BMCTRIG accesses the RTS tables and uses those values for exception evaluation. The BMCSTATS tables are not evaluated.

Bypass Exceptions

This option lets you suppress categories of exceptions from evaluation. You can suppress reorganization, statistics, or copy exceptions from evaluation. This option is particularly useful when you have defined system triggers

Example

If the following conditions apply:

  • You have defined system triggers for statistics and reorganization exceptions.
  • For this trigger run, you want to evaluate only reorganization exceptions.

You can suppress the statistics evaluations by specifying Stats Exceptions Y. This generates the TRIGNOSTATS keyword in the generated trigger syntax.

Indexes

This option indicates whether index exceptions are also evaluated when processing table spaces or table space sets. Y is the default. The PCTCLUS, FAROFF, and TOTALOFF exceptions are detected at the Index level, but cause generation of table space utilities. To detect these three types of executions, you must specify Indexes Y or run against indexes instead of table spaces.

 

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