Articles & Content


Maximizing DB2 Audit Logging Facility Without Compromising Application Performance (D10)

Topic: 2008 NA

Subtopic: DB2 for LUW

DATE: 2008-05-21 (01:30 PM - 02:30 PM)
SPEAKERS: James O'Leary (HSBC)

Utilizing the built-in Audit Facilities of DB2 UDB an appropriate level of auditing can be established without impacting database application performance. This presentation will illustrate how to establish a viable methodology in order to define, setup, implement, and monitor database auditable activities. Also included will be an explanation of the various audit event types, establishment of DB2 audit event tables and steps needed to extract audit information for reporting purposes.

EXP. LEVEL: Beginner,Intermediate,Advanced


Establishment of UDB audit logging at the appropriate level for a particular application.

Definition, setup, implementation and utilization of control commands for DB2 UDB Audit Logging.

How to create audit logging tables, population of tables, and establishment of maintenance jobs for the above.

Understanding the different audit event types.

How to utilize tools (Perfmon, LoadRunner) to assist in determining overhead of audit logging on a DB2 database.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.