idscfgauditdb

Use the idscfgauditdb command to create and configure the audit database that is required for audit reporting.

Description

The audit database is a DB2® database, where all the audit events from the audit log file of directory server instance are dumped. Use the idscfgauditdb command to create and configure the audit database. See Creating and configuring the audit database in the IBM® Security Directory Server documentation.

This utility uses the database schema file, sdsAuditDB.sql. Before you use this utility, you must make sure that the schema file is copied to the directory where this utility is located.

UNIX systems

Synopsis

idscfgauditdb    [ [-c | -r | -e] [-u user_name] [-w passwd] [-p db2_path]
                 [-s service_port] [-t db_name] [-d] [-v] ] | -h | -?

Options

The idscfgauditdb command takes the following parameters.

-c: Creates the DB2 instance and database.; You cannot use this parameter with the -r or -e options.; This parameter requires the -u, -w, -p, -s, and -t options.
-u user_name: Specifies the user name of the DB2 instance owner.
-w passwd: Specifies the password for the DB2 instance owner.
-t db_name: Specifies the name of DB2 database you want to create.
-p db2_path: Specifies the installation location of DB2.
-s service_port: Specifies the port at which the DB2 instance service must listen.
-r: Removes the DB2 database and instance.; You cannot use this parameter with the -c or -e options.; This parameter requires the -u, -t, and -p options.
-e: Indicates that the data from all DB2 tables in the database must be erased without dropping the tables.; You cannot use this parameter with the -c or -r options.; This parameter requires the -u, -t, -w, and -poptions.
-d: Runs in debug mode and shows the DB2 commands as they get executed.
-v: Shows verbose output.; This option also turns on the debug mode.
-h | -?: Shows the usage.

Windows systems

Synopsis

idscfgauditdb.cmd  [ [-c | -r | -e] [-u user_name] [-w passwd] [-l db_loc]
                   [-p db2_path] [-s service_port] [-t db_name] [-d] [-v] ] | -h | -?

Options

The idscfgauditdb.cmd command takes the following parameters.

-c: Creates the DB2 instance and database.; You cannot use this parameter with the -r or -e options.; This parameter requires the -u, -w, -p, -l, -t, and -s options.
-u user_name: Specifies the user name of the DB2 instance owner.; The user must exist on the system with a valid password.
-w passwd: Specifies the password for the DB2 instance owner.
-t db_name: Specifies the name of DB2 database you want to create.
-l db_loc: Specifies the location to create the database.
-p db2_path: Specifies the installation location of DB2.
-s service_port: Specifies the port at which the DB2 instance service must listen.
-r: Removes the DB2 database and instance.; You cannot use this parameter with the -c or -e options.; This parameter requires the -u, -t, -l, and -p options.
-e: Indicates that the data from all DB2 tables in the database must be erased without dropping the tables.; You cannot use this parameter with the -c or -r options.; This parameter requires the -u, -t, -w, -l, and -p options.
-d: Runs in debug mode and shows the DB2 commands as they get executed.
-v: Shows verbose output.; This option also turns on the debug mode.
-h | -?: Shows the usage.