You can use the Adabas Event Replicator Subsystem 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:

1. None of these requests can be processed if the Event Replicator Target Adapter is not fully activated. For complete information on fully activating Event Replicator Target Adapter processing, read Activating Event Replicator Target Adapter Processing.
2. Be sure you have the proper authorization privileges to maintain the RDBMS tables. User authorization to maintain any new RDBMS tables via Event Replicator Target Adapter is inherited from the site's privilege settings for the database. Authorization is managed by the user's RDBMS privileges and not by Event Replicator Target Adapter. Event Replicator Target Adapter does not grant RDBMS privileges to the user. Therefore, if you want to use Event Replicator Target Adapter to maintain tables in an RDBMS, verify that your RDBMS authorization privileges are correct for the maintenance you want to perform.

This document describes the methods by which you can control Event Replicator Target Adapter behavior.

• Populating the RDBMS Tables

• Clearing (Refreshing) the RDBMS Table Data

• Deleting (Dropping) RDBMS Tables

---

Populating the RDBMS Tables

Using the Adabas Event Replicator Subsystem, 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 the Adabas Event Replicator Subsystem, 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.

To submit a request to the Event Replicator Target Adapter to populate the RDBMS:

The Event Replicator Target Adapter must be installed, configured, and started or the request will not be processed until it is. For more information on installing and starting the Event Replicator Target Adapter, read Event Replicator Target Adapter Installation, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter.

1. Select option A from the Adabas Event Replicator Subsystem Main Menu.

   The Administration menu appears.

   14:53:47 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Administration M-RP1100 Code Function ---- ------------------------------- D Database ID I Perform Initial-State P PLOG Information R Initiate Replay S System Functions T Target Adapter V Global Values ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

2. Select option T on the Administration menu.

   The Target Adapter menu appears.

   18:46:03 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3010 Code Function ---- ------------------------------- P Populate R Refresh D Drop ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

3. Select P on the Target Adapter menu.

   The Target Adapter - Populate screen appears.

   18:46:23 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3020 Populate Initial-State .................. ________ DBID ........................... _____ File ........................... _____ Subscription ................... ________ Perform Drop Table ............. N Value Buffer ------------------------------------------------ ____________________________________________ ____________________________________________ ________________________________________ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Exec Menu

4. Supply values for the fields on this screen, as described in the following table:

   Field Name	Required?	Description
   Initial-State	Yes	The name of the initial-state definition in the Replicator system file that you want used to populate the RDBMS.
   DBID	Yes	The DBID of the Adabas database you want used to populate the RDBMS.
   File	Yes	The number of the file in the Adabas database you want used to populate the RDBMS.
   Perform Drop Table	No	Indicate whether a request to the Event Replicator Target Adapter to delete the tables (Drop) in the RDBMS should be performed before the RDBMS is populated (Populate). Valid values are "Y" (Yes) or "N" (No); the default is "N".
   Subscription	Yes	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.

5. When values for all required fields have been supplied, press PF5.

   The request is submitted to the Event Replicator Target Adapter.

Clearing (Refreshing) the RDBMS Table Data

Using the Adabas Event Replicator Subsystem, 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 the Adabas Event Replicator Subsystem, 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, configured, and started or the request will not be processed until it is. For more information on installing and starting the Event Replicator Target Adapter, read Event Replicator Target Adapter Installation, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter.

1. Select option A from the Adabas Event Replicator Subsystem Main Menu.

   The Administration menu appears.

   14:53:47 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Administration M-RP1100 Code Function ---- ------------------------------- D Database ID I Perform Initial-State P PLOG Information R Initiate Replay S System Functions T Target Adapter V Global Values ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

2. Select option T on the Administration menu.

   The Target Adapter menu appears.

   18:46:03 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3010 Code Function ---- ------------------------------- P Populate R Refresh D Drop ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

3. Select R on the Target Adapter menu.

   The Target Adapter - Refresh screen appears.

   18:48:02 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3021 Refresh DBID ........................... _____ File ........................... _____ Subscription ................... ________ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---

4. Supply values for the fields on this screen, as described in the following table:

   Field Name	Required?	Description
   DBID	Yes	The DBID of the Adabas database associated with the RDBMS data you want to cleared.
   File	Yes	The number of the file in the Adabas database of the file associated with the RDBMS data you want to cleared.
   Subscription	Yes	The name of the subscription definition in the Replicator system file associated with the RDBMS data you want cleared.

5. When values for all required fields have been supplied, press PF5.

   The request is submitted to the Event Replicator Target Adapter.

Deleting (Dropping) RDBMS Tables

Using the Adabas Event Replicator Subsystem, 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 the Adabas Event Replicator Subsystem, 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, configured, and started or the request will not be processed until it is. For more information on installing and starting the Event Replicator Target Adapter, read Event Replicator Target Adapter Installation, Event Replicator Target Adapter Administration, and Starting the Event Replicator Target Adapter.

1. Select option A from the Adabas Event Replicator Subsystem Main Menu.

   The Administration menu appears.

   14:53:47 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Administration M-RP1100 Code Function ---- ------------------------------- D Database ID I Perform Initial-State P PLOG Information R Initiate Replay S System Functions T Target Adapter V Global Values ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

2. Select option T on the Administration menu.

   The Target Adapter menu appears.

   18:46:03 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3010 Code Function ---- ------------------------------- P Populate R Refresh D Drop ? Help . Exit ---- ------------------------------- Code ... _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Menu

3. Select D on the Target Adapter menu.

   The Target Adapter - Drop screen appears.

   18:49:55 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2013-02-28 Target Adapter M-RP3021 Drop DBID ........................... _____ File ........................... _____ Subscription ................... ________ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Exec Menu

4. Supply values for the fields on this screen, as described in the following table:

   Field Name	Required?	Description
   DBID	Yes	The DBID of the Adabas database associated with the RDBMS tables you want to delete.
   File	Yes	The number of the file in the Adabas database of the file associated with the RDBMS tables you want to delete.
   Subscription	Yes	The name of the subscription definition in the Replicator system file associated with the RDBMS tables you want to delete.

5. When values for all required fields have been supplied, press PF5.

   The drop request is submitted to the Event Replicator Target Adapter for processing.