Displaying the Audit Log (DB2 UDB for UNIX and Windows) 

Use

You can track changes to the database using the maintenance actions provided in the DBA Cockpit.

Procedure

...

       1.      Call the DBA Cockpit.

       2.      In the navigation frame, choose  Audit.

The DBA Cockpit: Audit Log screen appears.

The audit log consists of the following fields:

Field	Description
Date	Start date of the action
Time	Start time of the action
System	Target system on which the action was performed
Action	Kind of action (name of the action in the DBA Cockpit)
Command	Type of command (for example, ADD, DELETE or EDIT)
Object	Name of the modified object (for example, database or tablespace name)
User	Name of the SAP user who performed the action
From System	System from where the action was performed.

 

       3.      By default, the system displays all audit entries that were logged during the current week. If you want to display another week, double-click a day in the calendar.

To display more than one week, you can change the field Number of Days.

       4.      To display the details of an action, select the corresponding action and choose  Details.

In the lower half of the screen, the SQL and CLP statements that have been executed are displayed.