Submitting Event Replicator Target Adapter Requests

#### Search Results

Search

# Submitting Event Replicator Target Adapter Requests

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.

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, 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.

### On this page

- Populating the RDBMS Tables
- Clearing (Refreshing) the RDBMS Table Data
- Deleting (Dropping) RDBMS Tables