IBM Utility History


Use the IBM Utility History panel to display information from the SYSIBM.SYSUTILITIES table. You can activate Utility History with ZPARM UTILITY_HISTORY=UTILITY.        

To view IBM Utility History tables

  1. From the BMC AMI Recovery for Db2 Main Menu, select  3. DB2 Subsystem Toolbox.
  2. In the Db2 Subsystem Toolbox panel, select D. IBM Utility History and press Enter.

    The IBM Utility History panel is displayed. 

    ARMUTL1 ================ IBM Utility History -  ===============================
    Command ===> ________________________________________________ Scroll ===> CSR_
                                                                                  
    Type the Utility ID, name, or Condition. Then press Enter.                     
     Utility                                                                       
        ID. . . . . ________________________________________________               
        Name. . . . ____________________________________________________________   
        Condition . _                                                              
        Start time. 2024 - 08 - 08 - 00 . 00 . 00 (YYYY-MM-DD-HH.MM.SS)            
                                                                                  
    Type S next to utility and press Enter to see more information.                
                                                                                  
       Utility ID      Condition   Name                  RC   Start Time           
    ******************************* Bottom of data ********************************
  3. (BMC.DB2.SPE2410) Perform the following steps:
    1. Specify any combination of the Utility ID, Utility Name, Condition, and Start Time and press Enter to display the utilities matching this criteria.  Utility ID, Utility Name, and Condition fields left blank are treated as wildcards. 

      Important

      The Utility ID and Utility Name can include the following wildcard characters:

      • You can use an asterisk (*) or percent sign (%) as a wildcard that replaces zero with any number of characters.
      • You can use a question mark (?) as a wildcard that replaces only one character.
      ARMUTL1 ================ IBM Utility History -  ================= Row 1 of 151
      Command ===> ________________________________________________ Scroll ===> CSR_
                                                                                    
      Type the Utility ID, name, or Condition. Then press Enter.                     
       Utility                                                                       
          ID. . . . . ________________________________________________               
          Name. . . . REORG_______________________________________________________   
          Condition . _                                                              
          Start time. 2023 - 11 - 14 - 12 . 59 . 43 (YYYY-MM-DD-HH.MM.SS)            
                                                                                    
      Type S next to utility and press Enter to see more information.                
                                                                                    
         Utility ID      Condition   Name                  RC   Start Time           
      _  DSNTEX            E         REORG                 000  2024-04-09-11.47.14  
      _  DSNTEX            E         REORG                 000  2024-04-09-11.47.16  
      _  DSNTEX            E         REORG                 000  2024-04-09-11.47.30  
      _  DSNTEX            E         REORG                 000  2024-04-09-11.47.34  
      _  DSNTEX            E         REORG                 000  2024-04-09-11.47.35  
      _  DOL1TEST          E         REORG                 000  2024-04-09-11.47.43  
      _  SCCOBU3A          E         REORG                 000  2024-04-10-12.47.32  
      _  SCCOBU3A          E         REORG                 000  2024-04-10-12.50.28  
      _  SCCOBU3A          E         REORG                 000  2024-04-10-12.56.13  
      _  SCCOBU3A          E         REORG                 000  2024-04-10-13.02.38  
      _  SCCSY03           E         REORG                 000  2024-04-10-13.20.34   
    2. You can modify the Utility ID, Utility Name, Condition, or Start Time and press Enter to redisplay the panel.
  4. Type S next to a utility and press Enter.The Utility History Detail panel is displayed.

    ARMUTL2 ================ IBM Utility History -  =====
    Command ===> ________________________________________
                                                        
      Utility Name . . . . . . REPORT RECOVERY           
      Job Name . . . . . . . . ARMD1D3                   
      Event Id . . . . . . . . 0000000000000001037       
      Utility Id . . . . . . . BMCARM3605879484          
      Start time . . . . . . . 2022-03-14-12.36.06.038291
      End Time . . . . . . . . 2022-03-14-12.36.06.043511
      Return Code. . . . . . . 000                       
      Execution Condition. . . E   ENDED                 
      Number of Objects. . . . 00001                     

 

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