You can use Event Replicator Administration to submit requests to the Event Replicator Target Adapter when it is activated. Ordinarily, once the Event Replicator Target Adapter processing is activated, replicated transaction data for the subscriptions and destinations are transformed and transferred to the Event Replicator Target Adapter to be applied to your RDBMS. In addition, though, you can request that the Event Replicator Target Adapter:
Initiate a request for initial-state data for a specific subscription, database, Adabas file, and data values to populate the RDBMS tables.
Clear the data in an RDBMS table, based on a specific subscription, database, and Adabas file.
Delete the RDBMS tables for a specific subscription, database, and Adabas file.
Notes:
This document describes the methods by which you can control Event Replicator Target Adapter behavior.
Using Event Replicator Administration, you can request that the Event Replicator Target Adapter initiate a request to populate the RDBMS tables with initial-state data for specific subscriptions, databases, Adabas files, and data values. When you submit the RDBMS population request from Event Replicator Administration, it is sent to the Event Replicator Target Adapter, which receives it and submits its own initial-state request to the Event Replicator for the data. The data is then transferred to the RDBMS via the usual processing of the Event Replicator Target Adapter.
Note:
If you submit a request to the Event Replicator Target Adapter to populate an RDBMS table that
does not exist, Event Replicator Target Adapter will create the table in the course of its normal
processing. However, if you submit a request to the Event Replicator Target Adapter to populate an
existing RDBMS table, it is your responsibility to clear or drop the existing
table prior to populating the RDBMS table with new data. For information on
clearing an RDBMS table, read Clearing (Refreshing) the RDBMS Table
Data; for information on dropping an RDBMS table, read
Deleting (Dropping) RDBMS
Tables.
To submit a request to the Event Replicator Target Adapter to populate the RDBMS:
The Event Replicator Target Adapter must be installed and started or the request will not be processed until it is. For more information on installing, configuring, and starting the Event Replicator Target Adapter, read Installing the Event Replicator Target Adapter, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter, in the Event Replicator Target Adapter documentation.
Select an Event Replicator Server in tree-view as described in Selecting Event Replicator Databases.
Click and expand Target Adapter in the tree-view under Replicators.
A table listing the Event Replicator Target Adapter functions appears in detail-view.
Click on Populate Table in the tree-view under Target Adapter.
A table listing the fields you need to specify to populate the RDBMS appears in detail-view.
Supply values for the fields in detail view, as described in the following table:
| Field Name | Required? | Description |
|---|---|---|
| Initial-State Name | Yes | From the drop-down list, select the name of the initial-state definition in the Replicator system file that you want used to populate the RDBMS. |
| Initial-State File | Yes | From the drop-down list, select the Adabas database DBID and file number in the database that you want used to populate the RDBMS. |
| Subscription Name | Yes | From the drop-down list, select the name of the subscription definition in the Replicator system file that you want used to populate the RDBMS. |
| Value Buffer | No | This field is not available for use at this time. |
When values for all required fields have been supplied, click .
The request is submitted to the Event Replicator Target Adapter.
Using Event Replicator Administration, you can request that the Event Replicator Target Adapter initiate a request to clear the data in the RDBMS tables for specific subscriptions, databases, and Adabas files. When you submit the RDBMS refresh request from Event Replicator Administration, it is sent to the Event Replicator Target Adapter, which receives it and clears the data out of the related tables, leaving the tables themselves in place.
To submit a request to the Event Replicator Target Adapter to clear data in the RDBMS:
The Event Replicator Target Adapter must be installed and started or the request will not be processed until it is. For more information on installing, configuring, and starting the Event Replicator Target Adapter, read Installing the Event Replicator Target Adapter, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter, in the Event Replicator Target Adapter documentation.
Select an Event Replicator Server in tree-view as described in Selecting Event Replicator Databases.
Click and expand Target Adapter in the tree-view under Replicators.
A table listing the Event Replicator Target Adapter functions appears in detail-view.
Click on Refresh/Drop Table in the tree-view under Target Adapter.
A table listing the fields you need to specify to refresh or drop the RDBMS data appears in detail-view.
Supply values for the fields on in detail-view, as described in the following table:
| Field Name | Required? | Description |
|---|---|---|
| DBID | Yes | From the drop-down list, select the DBID of the Adabas database associated with the RDBMS data you want to cleared. |
| File | Yes | From the drop-down list, select the number of the file in the Adabas database of the file associated with the RDBMS data you want to cleared. |
| Subscription Name | Yes | From the drop-down list, select the name of the subscription definition in the Replicator system file associated with the RDBMS data you want cleared. |
When values for all required fields have been supplied, click .
The request is submitted to the Event Replicator Target Adapter.
Using Event Replicator Administration, you can request that the Event Replicator Target Adapter delete the RDBMS tables (and their associated data) for specific subscriptions, databases, and Adabas files. When you submit the RDBMS refresh request from Event Replicator Administration, it is sent to the Event Replicator Target Adapter, which receives it and processes it.
To submit a request to the Event Replicator Target Adapter to delete tables in the RDBMS:
The Event Replicator Target Adapter must be installed and started or the request will not be processed until it is. For more information on installing, configuring, and starting the Event Replicator Target Adapter, read Installing the Event Replicator Target Adapter, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter, in the Event Replicator Target Adapter documentation.
Select an Event Replicator Server in tree-view as described in Selecting Event Replicator Servers.
Click and expand Target Adapter in the tree-view under Replicators.
A table listing the Event Replicator Target Adapter functions appears in detail-view.
Click on Refresh/Drop Table in the tree-view under Target Adapter.
A table listing the fields you need to specify to refresh or drop the RDBMS data appears in detail-view.
Supply values for the fields on this screen, as described in the following table:
| Field Name | Required? | Description |
|---|---|---|
| DBID | Yes | From the drop-down list, select the DBID of the Adabas database associated with the RDBMS tables you want to delete. |
| File | Yes | From the drop-down list, select the number of the file in the Adabas database of the file associated with the RDBMS tables you want to delete. |
| Subscription | Yes | From the drop-down list, select the name of the subscription definition in the Replicator system file associated with the RDBMS tables you want to delete. |
When values for all required fields have been supplied, click .
The request is submitted to the Event Replicator Target Adapter for processing.
