SQL scripts for installing the event and archive tables

The scripts to install the event, archive, and unique identifier tables for a DB2 database are:

The scripts to install the event, archive, and unique identifier tables for an Oracle database are:

The scripts to install the event, archive, and unique identifier tables for a Microsoft SQL Server database are:

These files are located in the following directories:

UNIX:

connectors/JDBC/dependencies/
   

Windows:

connectors\JDBC\dependencies\
   

Note:
These scripts are provided only as a template to assist you in creating the required tables for the connector. For other databases, please create your scripts using these as guidelines. The order and data type in the table columns is very important. Please refer to the Event and archive table schema to view the correct order and type.

It is recommended that the DBA or person implementing the connector modify these scripts to meet specific installation and query optimization requirements. For example, these scripts do not create indexes on the tables. It is the responsibility of the person implementing the connector to create indexes to enhance performance with the query optimizer.

Copyright IBM Corp. 1997, 2003