1. Home
  2. /
  3. Setup Guides
  4. /
  5. Security
  6. /
  7. Using DC1 DataBase Audit...
  8. /
  9. View, print and delete...

View, print and delete the DB audit log file entries

Related topics

View the DB audit log file

  1. Select the Database audit log file enquiry program.
  2. You access DB audit – log file enquiry. Select the record you wish to view in detail and click OK.
  3. On the detail panel, the following information is displayed for the selected record:
    4. Field name
    The name of the field that has been changed.
    Field value
    The value in the field.
    Sequence
    Can display Before update, After update, New record and Deleted record depending on the change.
    User
    The user ID of the person who made the change.
    Creation date and time
    Displays when the change was made.
    Updating program
    The name of the program where the changes were made.

    Use Display next and Display previous to view the next or previous record. For the purpose of this example, click Display transaction to view all changes that were made at one time for the fields in the file.

  4. You access DB audit – log information display. The layout of this panel depends on your layout. See Define the layout for the DB audit log file enquiry for more information. The header provides you with detailed information about the record. Click Before/After to toggle before and after update. The fields where changes were made will be updated.

Print the DB audit log file

Complete the following steps:

  1. Select the Print DB audit log file menu item.
  2. You access DB audit – log file printout:
    3. Sequence
    The first four fields are used for sequencing the printout.
    Selection
    The first four fields are used for data selection whereas the following four fields are used for status selection.
    Print
    Complete the fields according to the printer settings.

    Click OK.

Printout explanation
The two first columns identify the file. The next two columns are the field identifier and its description. The Identity column heading lists the value of the identifying field in the record. In the Field value columns there will be entries if the value of the field have been changed. The rightmost column displays the kind of change that has been carried out, for example new.

Delete log transactions

It is important to periodically delete the transactions in the log file. How often you should do this depends on the number of files and fields activated for DBAM and the amount of records that change.

  1. Select the Delete DB audit log transactions menu item.
  2. You access DB audit – log transaction deletion. Complete the fields according to your needs and click OK.

Related topics