Log Display Facility

Each DDL statement executed through the CA Batch Processor, as well as every edit or browse session, is logged in a history file. The Log Display Facility enables users to review the history log.
carcupdb218
Each DDL statement executed through the CA Batch Processor, as well as every edit or browse session, is logged in a history file. The Log Display Facility enables users to review the history log.
DB2 does not record when an object was dropped or altered in the catalog. The Log Display Facility provides an audit trail of changes not available from DB2. The log can be invaluable in tracking changes to DB2 objects.
With the Log Display panel, users can choose to view any portion of the history log. The panel initially defaults to show the actions performed during the current day. Selection criteria can be changed to view the listings of any command executed by any user at any time.
Access a Log Display Panel by entering L (Log) in the Option Field on any screen. An example Log Display is shown in the next two sections.
The Log Maintenance feature is available as option W on the CA Database Management Solutions for DB2 for z/OS main menu. This feature allows the user to display, backup, purge, or restore log records. This feature does not affect the way Log Display works within the product; instead, it gives the user additional control over the Log records, accessible from outside the product. 
Controlling the Log Display
The log display is controlled by changing the selection criteria entered in the header or by using the Extended Query Facility (EQF).
The Log Display lists the activity from the log history file according to the criteria entered in the header and through EQF. It is a display-only area of the panel where all information is protected from entry. Scroll the display using scrolling commands.
Press F3 (End) to return to the Main Menu.