DB2 Audit Management Expert

DB2 Audit Management Expert (DB2 AME) offers comprehensive, detailed auditing capabilities to help database administrators, security administrators and auditors deliver accurate, timely data and reports for use in auditing activities.

• Provides detail on who made changes to the data as well as where and when the changes were made
• Lets auditors participate in data auditing activities with less DBA involvement – freeing up valuable IT staff resources
• Eliminates manual auditing processes that can be time consuming and error prone

Compliance failures can have enormous costs to your business. DB2 Audit Management Expert, which is part of a larger IBM Data Governance solution, provides the auditing capabilities IT organizations need to help minimize the liability associated with growing compliance demands.

• Selectively audits inserts, updates, deletes, and reads of DB2 systems
• Provides views of all reported activity on specific DB2 objects (such as read, change, and z/OS utility access)
• Collects trace data in an audit repository, and then views, analyzes and generates reports on the data
• Does not require auditors to log into DB2 and does not permit them to directly manipulate any DB2 resource
• Supports an easy to use interface for both auditors, DBAs, and security administrators allowing them to work together to deliver accurate data for use in audit activity
• Allows an authorized auditor to investigate an exposure by reviewing what data has been changed in the system
• Offers a user-friendly administration interface that enables DB2 AME administrators to easily define DB2 AME entities such as users, groups and collection criteria

For auditing DB2 in a z/OS environment DB2 Audit Management Expert also lets you:

• View all DML SQL statements and their host variables allowing the user to identify the actual row that was accessed
• Take advantage of a Data Capture Facility that provides controllable, time-unlimited data capture without DB2 trace dependency or limitations
  • Captures SQL statements (dynamic & static)
  • Captures the host variable values
  • Shares collector/overhead with DB2 Query Monitor

Program Number:
DB2 Audit Management Expert for z/OS (5655-I16)
DB2 Audit Management Expert for Multiplatforms (5724-L84)

IBM Data Governance Solution

DB2 Audit Management Expert for Multiplatforms V1.1

Hardware Requirements

• Server and agent:
  • Any hardware capable of running AIX 5L V5.2 or AIX 5L V5.3
  • Memory and disk space sufficient to fulfill DB2 minimum requirements
  • AIX installation: Approximately 150 MB of free disk space
  • Additional space for user data (varies depending on the size of your databases and the amount of activity your system encounters); script adhDbSetup.sh installs two 400 MB tablespaces for the repository

• Client:
  • Any hardware that is capable of running Windows XP
  • Minimum 150 MB free disk space (500 MB to download and extract)
  • Minimum 512 MB memory

Software Requirements

Server requirements

• IBM DB2 running locally: This release of DB2 Audit Management Expert for Multiplatforms requires you to run DB2 locally.
• Ability to connect to a DB2 database: To run DB2 Audit Management Expert for Multiplatforms, you must be able to connect to a DB2 database. v
• C++ Runtime environment on AIX: DB2 Audit Management Expert for Multiplatforms requires the C++ Runtime environment fileset, V5.0.2.0, or later, installed on AIX.

Client requirements

• Operating environments: Windows XP
• IBM JDBC driver (Reporting client only): To run DB2 Audit Management Expert for Multiplatforms, you must install the IBM JDBC driver. This driver is included with the DB2 Runtime client. DB2 Audit Management Expert does not include this component.
• Java
  • If there is no Java Runtime Environment (JRE) present in the DB2TOOLS directory, DB2 Audit Management Expert installs a JRE into a folder entitled JRE142\jre which resides in the DB2TOOLS directory of the user's installation directory.
  • For example, a typical path on a Windows machine is:
    • C:\Program Files\DB2TOOLS\JRE142\jre
    • Note: The default installation directory is selected based on the existence of a DB2TOOLS environment variable.
• A Web browser (for online help system)
  • DB2 Audit Management Expert uses an Eclipse-based help system with the following software requirements:
    • On Windows systems, the help system requires Microsoft Internet Explorer V6.0, or later, or Mozilla-based browsers Version 1.7, or later.

DB2 Audit Management Expert for z/OS, V2.1

Hardware Requirements

The DB2 Audit Management Expert client will operate on any hardware capable of running Windows 2000 or Windows XP with a minimum of:

• 150MB free disk space
• 512MB memory

Software requirements:

• z/OS, V1.6 (5694-A01), or later OR
• z/OSe, V1.6 (5655-G52), or later
• DB2 for z/OS, V7 (5675-DB2) OR
• DB2 for z/OS, V8 (5625-DB2)
• z/OS Integrated Cryptographic Service Facility (ICSF) must be enabled at the server's host. This enablement is no longer required if the following APAR is installed: APAR PK36872.
• Client requirements are:
  • Windows 2000 Professional or Windows XP Professional (32-bit)
  • DB2 JDBC Driver V2.3.63, or later
  • DB2 for Windows DB2 Connect to enable the connection to the DB2 Audit Management Expert repository.

For more information on system requirements for DB2 Audit Management Expert, please see the Program Directory on the Library page.