You need to create the event store in the database before
the adapter can process inbound events. You can set triggers on user
tables as needed to populate the event table.
About this task
Perform this task only if you need inbound processing of
events. Create the event store in the database that contains the tables
for which events are reported.
Procedure
- Create the event store. Sample scripts
are provided to create the event store for the IBM® DB2®, IBM DB2 for z/OS®, Oracle, or Microsoft SQL Server database, as follows:
- scripts_db2.sql
- scripts_db2_zOS.sql
- scripts_oracle.sql
- scripts_mssql.sql
Note: Before you run the scripts_db2_zOS.sql script,
ensure that the storage group JDDBSTO exists.
These files
are in the IID_installation_dir/ResourceAdapters/JDBC_version/Scripts directory,
where IID_installation_dir is the installation
directory for IBM Integration Designer,
and version identifies the version of the adapter.
- If necessary,
set up triggers on user tables so that changes to the user tables
can automatically generate events that are stored in the event store.
The sample scripts contain examples of how to create triggers to populate
your event store.
Results
The event store is available for event processing.