Viewing and deleting utility history rows

You can view and delete rows from the utility history table using Db2 Automation Expert's Utility History panel.

1. On the Db2 Automation Expert main menu, enter 13 in the Option field and press Enter.
2. On the Utility History panel, specify selection criteria to filter the utility history rows, or press Enter without entering selection criteria to see all rows. The utility history rows that meet your selection criteria are listed on the Utility History panel. An example is shown in the following figure:

    AUTOXPRT V1R1   ------------ Utility History ------------ 2023/10/21  19:19:01 
    Option  ===>                                                  Scroll ===> CSR  
    -------------------------------------------------------------------------------
    Commands: Delete - Delete all                                                  
    Line Commands: O - Overview  D - Delete                                        
    -------------------------------------------------------------------------------
     Utility Name   *                                                              
     Started From                                           (Timestamp expression) 
     Started To     &CURRENT                                (Timestamp expression) 
     Return Code >= 0    (Integer, NULL, Blank)                                    
     Condition        (E-Ended, T-Term, F-Forced, Blank)    Db2 Subsystem: SS1A    
     Job Name       *           Userid   *                  Row 1 of 2086       +> 
    -------------------------------------------------------------------------------
                               Ret  C R Number  Elapsed Time    CPU Time           
    Cmd Utility       Jobname  Code o e Objects HH:MM:SS:NNNNNN HH:MM:SS:NNNNNN    
        COPY          SS1APARG 0    E N 7       00:00:24:459268 00:00:01:779859    
        CHECK INDEX   SS1APARG 0    E N 7       00:00:08:911991 00:00:00:589626    
        COPY          SS1APARG 0    E N 7       00:00:20:233142 00:00:01:835927    
        COPY          SS1APARS 0    E N 7       00:00:00:297051 00:00:00:105610    
        COPY          SS1APARS 0    E N 7       00:00:13:737685 00:00:00:880574    
        COPY          SS1APARS 0    E N 7       00:00:22:771098 00:00:01:308898    
        CHECK INDEX   SS1APARS 0    E N 7       00:00:12:161515 00:00:00:638375    
                                                                                   
                                                                                   

3. To view all of the values of a utility history row on one panel, enter O next to a row and press Enter.
   The Utilities History Overview panel shows the contents of the selected utility history row on one non-scrollable panel.
   Press PF3 to return to the Utility History panel.
4. To delete one or more rows from the utility history table, do one of the following:
   Warning: Deleting utility history rows cannot be undone without recovering the entire table.
   • To delete a history row, enter D next to a row and press Enter.
   • To delete all history rows that are currently displayed, enter DELETE in the Option line and press Enter.
   A window is displayed to confirm deletion of the row.

   • To delete the row, enter YES in the Confirm field and press Enter.
   • To cancel, press PF3.
5. When finished viewing utility history, press PF3 (END).