Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Thresholds in BMCTRIG syntax


In the syntax for the BMCTRIG utility, you can specify thresholds for each exception that BMC Software supplies.

Before you begin

To set the thresholds by using the BMCTRIG syntax, you must first perform the following operations:

  1. Create an action that contains BMCTRIG as instructed in Creating-a-Service-Action.
  2. Create syntax for BMCTRIG to use with the BMCTRIG action as instructed in Copying-a-Service-Action.
  3. Specify threshold values for the exceptions that you want to monitor.

    DASD MANAGER PLUS displays panels for the exceptions for you to enter threshold values. When you generate the BMCTRIG action, the syntax indicates the exceptions and thresholds that you specified. Unless you set the SYSTRIGS option to F (FORCE) in the installation options module, BMCTRIG uses the thresholds that the syntax specifies for the objects that it processes.

    If the SYSTRIGS option is Y in the installation options module or SYSTEMTRIGGERS is Y, BMCTRIG also evaluates the exceptions that you have defined for the subsystem that you have not specified in the syntax. In this situation, the thresholds that you specify in the syntax override the thresholds in the system triggers.

To set thresholds in BMCTRIG syntax from the main BMCTRIG panel

  1. Access the main BMCTRIG panel as follows:
    1. Create an action for BMCTRIG or select the one that you have already defined as instructed in Creating-a-Service-Action.
    2. Edit the BMCTRIG service as instructed in Copying-a-Service-Action.The main BMCTRIG anel (see the following figure) appears.

      Important

      If you plan to analyze Db2 RTS exceptions, change the Db2 RTS option to Y or O in the What to Analyze section of the BMCTRIG Service Syntax panel.

      BMCTRIG main panel

        DEMO                  BMCTRIG TABLESPACE QZUD40.%            Row 1 to 37 of 217
        Command ===>                                                  Scroll ===> CSR   
                                                                                       
        Service Syntax: BMCTRIG.TRIGDEMO                                                
                                                                                       
        Type Service Syntax options. Then press End.                        More: +     
                                                                                       
        -------------------------- Processing Options ---------------------------------
        Select . . . . . . 1        1. Evaluate and Generate                            
                                    2. Evaluate Exceptions                              
                                    3. Generate Jobs                                    
                                    4. Evaluate Exceptions for Automation               
                                    5. Resume Generation                                
                                                                                       
                                                                                       
                                                                                       
        -------------------------- What to Analyze ------------------------------------
        System Triggers             (Y/N - use exceptions and actions in DASD tables)   
        DB2 RTS  . . . . . N        (Y/N/O - Y-Use RTS, N-Ignore RTS, O-Use Only RTS)   
        Bypass Exceptions:                                                              
         Reorg Exceptions           (Y/N - Bypass analysis of Reorg-Related Exceptions)
         Stats Exceptions           (Y/N - Bypass analysis of Stats-Related Exceptions)
         Copy Exceptions            (Y/N - Bypass analysis of Copy-Related Exceptions)  
        Indexes  . . . . . Y        (Y/N - Include all indexes in tablespace)           
                                                                                       
        -------------------------- Saving and Reporting Exception Options -------------
        Save . . . . . . . Y        (Y/N - Save Exceptions in Exceptions table)         
        DELETEAGE  . . . . 32767    (Delete Exceptions older than this many days)       
        REPORT . . . . . . Y        (Y/N - Print Report on objects with exceptions)     
        FKEY0MSG . . . . . Y        (Y/N - Allow notification of empty indexes)         
        MSGLEVEL . . . . . 0        (0/1 0-Normal msgs, 1-Additional msgs)              
                                                                                       
        -------------------------- Eliminate Duplicates and Index Escalation Options --
        IX Escalate  . . . Y        (Y/N/A - Escalate IX's to TS's during generation)   
        IX Copy  . . . . . N        (Y/N - Copy indexes)                                
        Remove dup actions Y        (Y/N - Eliminate duplicate actions)                 
        Detect inline opts Y        (Y/N - Eliminate actions based on inline options)   
         
  2. Scroll down until Override System Trigger Exceptions appears, as shown in the following figure.Override Thresholds panel in BMCTRIG Override System Trigger panel

    DEGG                  BMCTRIG TABLESPACE QZUD40.%         Row 101 to 137 of 211
     Command ===>                                                  Scroll ===> CSR  
                                                                                   
     Service Syntax: BMCTRIG.TRIGDEMO                                               
                                                                                   
     Enter data, then press end.                                         More: + -  
     -------------------------- Override System Trigger Exceptions -----------------
     -------------------------- Reorg-Related Override Exceptions ------------------
     DB2 RTS Specific Reorg Exceptions:                                             
      Shared Tablespace/Index Exceptions:                                           
       Mods since reorg          (1-100 % rows modified since reorg)                
       Ins since reorg           (1-100 % rows inserted since reorg)                
       Del since reorg           (1-100 % rows deleted since reorg)                 
       Mass del reorg   N        (Y/N - Mass delete since last reorg)               
      Tablespace Exceptions:                                                        
       Unclust inserts           (1-99 Percent unclustered inserts)                 
       Reorg DISORG LOB          (1-100 % disorganized LOBs inserted since reorg)   
       Pct over alloc            (Space Allocated / Space Used > % Specified)       
      Index Exceptions:                                                             
       Append inserts            (1-100 Percentage of keys appended)                
       Reorg Leaf . . .          (1-100 Percentage that NPAGES exceeds NLEAF)       
     DB2 RTS or BMCSTATS Reorg Exceptions:                                          
      Shared Tablespace/Index Exceptions:                                           
       Dataset Extents           (1-7257 Number of extents per dataset)             
       AREO* pending    N        (Y/N - Advisory REORG pending)                     
       AREOR pending    N        (Y/N - Advisory REORG pending and pending DDL)     
      Tablespace Exceptions:                                                        
       FARIND . . . . .          (0-99 Percent far indirect reference)              
       TOTALIND . . . .          (0-99 Percent total indirect reference)            
       Reorg Pend . . . N        (Y/N Reorg pending flag is on)                     
      Index Exceptions:


 

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