Creating and configuring the audit database

The audit database is a DB2® database, where all the audit events from the audit log file of directory server instance are dumped. You can create and configure the audit database by using the scripts that are provided when you install IBM® Verify Directory.

About this task

IBM Security Directory Server audit reporting supports only DB2 database.

Procedure

  1. Install DB2 on the system where you want the audit database to be created.
  2. Copy the idscfgauditdb utility and the sdsAuditDB.sql file from the following locations:
    UNIX™ systems
    sds_install_dir/report/idscfgauditdb
    sds_install_dir/report/sdsAuditDB.sql
    Windows™ systems
    sds_install_dir\report\idscfgauditdb.cmd
    sds_install_dir\report\sdsAuditDB.sql
  3. Place both the files in the same directory on the system where you want the audit database to be created.
  4. Run the idscfgauditdb utility with appropriate parameters. See idscfgauditdb utility in the IBM Verify Directory documentation.

Results

The audit database instance, database, and the tables are created.

What to do next

Install and configure the reporting components.