Viewing the Db2 Table Editor activity log

Db2 Table Editor logs all activity that takes place within the ISPF interface.

Procedure

  1. To view user activity in Db2 Table Editor, specify option 2 (Display log) on the Option line of the Db2 Table Editor main panel (ETI$MAIN) and press Enter.
    Figure 1. The Log Display panel (ETI$LOG)
    
    ETI$LOG            Log Display - SSID: DA1A               2017/02/02  10:36:17 
     Command ===> ________________________________________________ Scroll ===> PAGE 
                                                                                    
     Commands: CLEAR - Clear search criteria  EXPORT - Export data                  
                                                                                    
     Creator like . . ________________________________________  >                   
     Name like  . . . ________________________________________  >                   
     Timestamp  . . . _____________________ (YYYY/MM/DD hh:mm:ss)                    
     Row count  . . . ___(EQ, NE, GT, LT)                                           
     Action . . . . . ______ (Update, Delete, Insert, Edit, Browse)                 
     User ID  . . . . PDMONA                                                  
                                                                           Row      
     Action Row Count  Timestamp           Creator  Name                 User ID    
     ------ ---------- ------------------- -------> -------------------> --------   
     EDIT              2017/01/30 16:40:56  ETITST  ETI_RT_ORG           PDMONA
     UPDATE          3 2017/01/30 16:40:56  ETITST  ETI_RT_ORG           PDMONA
     ******************************* Bottom of data ********************************
    
    Note: If logging is not enabled, then you will receive an informational message instructing you to reconfigure Db2 Table Editor for use with logging.
  2. To filter data, on the Log Display panel (ETI$LOG), specify search criteria in the following fields, which appear at the top of the panel, and press Enter to view the filtered data.
    Field Description
    Creator or Creator like To search for data in the log table by the object’s creator, specify a name of up to 128 characters. This field is scrollable, which enables you to specify longer creator names. You can also specify wildcard characters (* or %) in this field to return all creator names.
    Tip: The Creator field can be displayed as Creator like. You can use the LIKE command on the ETI$MAIN panel to toggle the LIKE operator on and off.
    Name or Name like To search for data in the log table by the object’s name, specify a name of up to 128 characters. This field is scrollable, which enables you to specify longer object names. You can also specify wildcard characters (* or %) in this field to return all names.
    Tip: The Name field can be displayed as Name like. You can use the LIKE command on the ETI$MAIN panel to toggle the LIKE operator on and off.
    Timestamp To search for data in the log table by the timestamp when the object's data was affected by an insert, update, or delete action, specify a timestamp in the following format: YYYY/MM/DD hh:mm:ss. To view all timestamps, leave this field blank.
    Row count To search for data in the log table by the number of rows affected by an insert, update, or delete action, specify one of the following conditional operators: EQ (equal), NE (not equal), GT (greater than), or LT (less than) followed by the number of rows. To view all data, leave this field blank.
    Action To search for data in the log table by the action performed (update, delete, insert, edit, or browse), specify one of the following actions: Update, Delete, Insert, Edit, or Browse. To view all actions, leave this field blank.
    User ID To search for data in the log table by the user who made the change, specify their user ID. To view all users, leave this field blank.

    When you specify multiple search criteria, each entry is joined together by AND and searched together. To clear criteria and begin a new search, use the CLEAR command. This clears all criteria in the search criteria fields so that you can specify new search criteria.

    When you specify search criteria and press Enter, information is displayed in the following fields:

    Field Description
    Action The action that occurred on the object. Valid values are Update, Browse, Insert, Delete, or Edit (which indicates that you specified EDIT mode on a table).
    Row Count The number of affected data rows as a result of an update, insert, or delete.
    Timestamp The recorded timestamp when the corresponding action was performed on the data. This is the system timestamp.
    Creator The creator of the Db2® object. If the object is a table, then this is the creator of the table. If the object is a view, then this is the creator of the view. This value can be up to 128 characters. This field is scrollable if the content is longer than 8 characters.
    Name The name of the Db2 object. If the object is a table, then this is the name of the table. If the object is a view, then this is the name of the view. This value can be up to 128 characters. This field is scrollable if the content is longer than 16 characters.
    User ID The user ID associated with the corresponding action.

    Data within columns can be sorted using the standard ISPF panel CSORT command, or by pressing Enter when the cursor is on the column name. The CSORT command sorts data in ascending or descending order. For more information about sorting data, see Sort rows and columns.

  3. To define log export parameters and export Db2 Table Editor data, on the Log Display panel (ETI$LOG), specify EXPORT on the Command line and press Enter.
    Figure 2. The Log Export Settings panel (ETI$LSET)
    
                                Log Export Settings               
     ETI$LSET                                                     
     Export log in:                                               
       File name . . PDMONA.ETI.LOGEXP                      
                                                                  
     Processing options                                           
       Enter "/" to select option                                 
           Specify new data set allocation parameters             
                                                                  
     Press ENTER to export log                                    
     Press F12 to cancel                                          

    On the Log Export Settings panel (ETI$LSET), specify a file name in the Export log in Filename field. To specify data set allocation parameters, select the Specify new data set allocation parameters option with a forward slash (/). To export the log, press Enter. To cancel, press F12.