Viewing the Db2 Table Editor activity log
Db2 Table Editor logs all activity that takes place within the ISPF interface.
Procedure
-
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. - 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.
-
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.