Configuring the database schema
Configuring the database schema involves running the appropriate audit or reporting mode SQL scripts for the target database. The scripts provided in the audit and reporting mode libraries are designed to cover general use cases. You will probably need to modify them to work with your database settings or to suit your particular requirements.
The audit and reporting mode libraries contain SQL scripts
that create all the database schema objects required to store data
processed by the gateway, including the tablespace, temporary tablespace,
reporter, tables (status, journal, and details), indexes, and constraints.
Use either the audit mode scripts or the reporting mode scripts to create the database schema objects, as required. See Audit mode and reporting mode for details of how the gateway operates in each mode.
Running the scripts
The installed scripts are located in subdirectories of the $OMNIHOME/gates/audit and $OMNIHOME/gates/reporting directories, named for the target database that they configure. For example, the scripts for IBM® DB2® are located in the $OMNIHOME/gates/audit/db2 and $OMNIHOME/gates/reporting/db2 subdirectories.
Before running the scripts, you should consult your database documentation for instructions about how your database uses SQL scripts. You should also refer to the readme files in the script libraries and the comments in the script files for details of any limitations or constraints specific to individual scripts.