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.

Creating user-defined exceptions


A user-defined exception consists of a name and one or more REXX programs that are used to evaluate exceptions.

Before you use a user-defined exception in BMCTRIG, however, you must create one or more REXX programs that will evaluate the thresholds for the exception. Also, you must ensure that the SYSEXEC DD that BMCTRIG uses refers to the data set that contains the REXX program. You set the value for SYSEXEC in the JCL Generation POF. For more information, see Setting-up-DASD-MANAGER-PLUS. For more information and samples of the REXX program requirements for user-defined exceptions, see REXX-programs.

Important

You must code the SYSTSPRT DD as a SYSOUT file if SYSTRIGGERS is Y and you have specified user-defined exceptions. The REXX driver always writes out at least two lines to the SYSTSPRT DD for every REXX program executed. If the REXX program executes a SAY instruction, then the output goes to the SYSTSPRT DD. If BMCTRIG executes under AEXEMAIN, then you must specify SYSTSPRT DD SYSOUT.

To create a user-defined exception

  1. On the DASD MANAGER PLUS Main Menu, select Object Exceptions.The Detect and Correct Object Exceptions panel is displayed.

    DEBA ------------------ Detect and Correct Object Exceptions ------------------
    Command ===>                                                                   
                                                                                  
    BMCTRIG is a DASD MANAGER utility that identifies and logs changes             
    (Exceptions) in a database and optionally creates maintenance jobs             
    (Corrective Actions) in response to these changes.                             
                                                                                  
    Select an option. Then press Enter.                                            
       1. Define and manage Exception detection conditions                         
       2. Define and manage Object-Action priorities                               
       3. Create a new BMCTRIG Service Action                                      
       4. Manage existing BMCTRIG Service Actions                                  
       5. Restart a WORKLIST format job that was generated by BMCTRIG              
       6. View logged Exceptions needing Corrective Action generation
  2. Select Define and manage Exception detection conditions and press Enter.The Exceptions Menu panel is displayed.

    DEBA ----------------------------- Exceptions Menu -------------------------
    Command ===>                                                                
                                                                               
    An Exception is a condition you want DASD MANAGER to detect. Type a specific
    Exception or type a wildcard pattern for a selection list.                  
                                                                               
    Exception . . . %                                                           
                                                                               
    Select an option. Then press Enter.                                         
       1. List                                                                  
       2. Create a new User Define Exception                                    
       3. Edit Exception Thresholds                                             
       4. Edit Exception Corrective Actions                                     
       5. Edit Exception Properties                                             
       6. Copy an Exception                                                     
       7. Delete an Exception
  3. (optional) If you know the name of the desired exception name, enter the exception name, select Create a new User Defined Exception, and then skip to 5.
  4. Select List and press Enter.The Exceptions List is displayed.

    DEBA ------------------------- Exceptions List ------       Row 1 to 26 of 68  
    Command ===>                                                  Scroll ===> PAGE
                                                                                  
    Exception: %                                                                   
                                                                                  
    An Exception is a condition you want DASD MANAGER to detect. Select one        
    or more actions. Then press Enter.                                             
                                                                                  
    Sort by. . 1  (1=Name, 2=Category)                                             
                                                                                  
    C =Create   D =Delete   P =Properties   L =Like   A =Active Exceptions         
    R =Edit Corrective Actions   T =Edit Thresholds                                
                                                                     More:     + >
                  Apply To   Aging                                                 
    Act  Name      Ts  Ix    Incr   User  Category     Identifies                  
    ******************************** Top of data **********************************
         ACHKPEND   Y   N      0      N   CHECK      DB2 Status Condition          
         APPNDINS   N   Y      0      N   REORG      Disorganized Data             
         AREOPEND   Y   Y      0      N   REORG      DB2 Status Condition          
         ARERPEND   Y   Y      0      N   REORG      DB2 Status Condition          
         AYSYRAT    Y   Y      0      N   REORG      Object Performance Degradation
         BSTATAGE   Y   Y      0      N   STATS      Out of Date Stats/Copy        
         CARD       Y   Y      0      N   REORG      Change in Amount of Data      
         CHKPEND    Y   Y      0      N   CHECK      DB2 Status Condition          
         COPY#IIC   Y   N      0      N   COPY       Change in Object Data         
         COPYAGE    Y   N      0      N   COPY       Out of Date Stats/Copy        
         COPYMODS   Y   Y      0      N   COPY       Change in Object Data         
         COPYPEND   Y   Y      0      N   COPY       DB2 Status Condition          
         CSTATAGE   Y   Y      0      N   STATS      Out of Date Stats/Copy        
         DIRTY      Y   N      0      N   COPY       Change in Object Data         
         DIRTYIC    Y   N      0      N   COPY       Change in Object Data         
         DSEXTENT   Y   Y      0      N   REORG      Data Set Fragmentation        
         EXTENTS    Y   Y      0      N   REORG      Data Set Fragmentation        
         FARIND     Y   N      0      N   REORG      Disorganized Data             
         FAROFF     N   Y      0      N   REORG      Disorganized Data             
         FICAGE     Y   N      0      N   COPY       Out of Date Stats/Copy        
         GIPCDEC    Y   Y      0      N   REORG      Object Performance Degradation
         ICPYPEND   Y   Y      0      N   COPY       DB2 Status Condition          
         IXDIRTY    N   Y      0      N   COPY       Change in Object Data         
         IXICAGE    N   Y      0      N   COPY       Out of Date Stats/Copy        
         LEAFDIST   N   Y      0      N   REORG      Disorganized Data             
         LEAFFOFF   N   Y      0      N   REORG      Disorganized Data
  5. Add a new exception by typing C in the Act field next to an Exception.The Create User Exception panel is displayed

    DEBA ------------------------- Create User Exception  -------------------------
    Command ===>                                                                   
                                                                                  
    Type new User Exception data. Then press Enter.                                
                                                                                  
    Name  . . . . . .                                                              
    Category  . . . .          (COPY, REORG, STATS, REPORT, OTHER)                 
    Applies to TS . . Y        (Y/N applies to table spaces)                       
    Applies to IX . . Y        (Y/N applies to indexes)                            
    Aging Increment .   0      (0-255 to increment priority per day)               
    Description . . .                                                              
    Long Description
  6. Enter a unique name for the exception, keeping in mind the following considerations:
    • BMCTRIG uses the name for reporting the exception.
    • You should specify whether the exception applies to table spaces, indexes, or both.
    • (optional) You can specify the aging priority (the same as you would for exceptions that BMC Software supplies).
    • (optional) You can specify the exception Category (COPY, REORG, STATS, REPORT, or OTHER).
  7. Press END to save your changes.The Create Exception Threshold panel is displayed. (For an example of the panel, see Creating-a-new-threshold).


 

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