Overview of the main features of BMCTRIG

Because every Db2 application has different requirements for availability and performance, the amount of update activity differs for each application.

These requirements affect when you should perform maintenance (such as reorganizations) on objects. DB2 does not provide an automated way of determining when an object needs maintenance. Often, you need to use SQL and IDCAMS reports to try to determine which objects require maintenance. Running reorganizations and copies on a scheduled basis rather than only when the object is exceeding site guidelines can be costly in terms of wasted CPU cycles and work hours. DASD MANAGER PLUS allows you to test for user-defined thresholds, and if exceptions occur, to take user-defined corrective action.

Related Topics

By using the BMCTRIG utility, you can monitor changes in your database statistics. BMCTRIG reports significant changes (exceptions) and automatically creates maintenance jobs to perform the actions that you specify based on the condition of your Db2 objects.

You define the exception thresholds that BMCTRIG monitors. You can set different thresholds for different objects in your subsystem and you can assign a priority to specific thresholds to indicate the severity of the condition. When executed, BMCTRIG checks for objects that meet or exceed the thresholds that you have defined.

If thresholds are exceeded, BMCTRIG takes a user-defined action. The following user-defined actions are examples:

  • Record the exception in the Exceptions Table, logging when the exceptions occurred, and what the threshold and actual values were for the exception.
  • Produce a batch report when BMCTRIG encounters an exception condition that contains the following information:
    • Exception condition
    • Object name and type
    • Current value of the statistic
    • Compare value and threshold value
    • Corrective action taken (such as a user-defined REORG utility job)

  • Generate maintenance jobs that use the corrective actions that you defined.

    BMCTRIG uses priorities to order work and to limit generation of corrective action work. The corrective actions can include any utilities that DASD MANAGER PLUS supports or your own (user-defined) program.

 

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