Maintaining logs

During the installation of 

Catalog Manager

, several Db2 tables are created to store various types of logged information.

The logs that are maintained by Catalog Manager are the Session Log, DDL Audit Log, and Drop Recovery Log. The log data is displayed in typical list panels. You can execute commands against items on the log list panels.

These tables, or logs, provide flexibility, efficiency, and integrity in reporting. User setup is minimal because logged information is captured automatically.

Important

To use the log maintenance functions described in this section, you must have the following authorities:

  • EXECUTE authority on the Catalog Manager Log Table Maintenance plan.
  • To use functions to browse the logs, you must have SELECT authority.
  • To use purge functions, you must have DELETE authority on the Catalog Manager Log Table Maintenance plan.

GUID-47E5A770-A760-442A-9F5A-06872981813D-low.png

For more information, view the Quick Course Using Logs.

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*