Table of Contents Previous Next


5 Single-Master Replication Operation : 5.5 Managing a Subscription

Note: This section discusses various aspects of managing a subscription of a replication system. For a similar discussion on managing a publication of a replication system, see Section 7.6.
Step 1: The subscription server whose login information you want to save, change, or delete in the server login file must be running before you can make any changes to the file. See Step 1 of Section 5.3.1 for directions on starting the subscription server.
Step 2: Click the secondary mouse button on the Subscription Server node and choose Update. The Update Subscription Server dialog box appears.
Step 3: Complete the fields in the dialog box according to your purpose for updating the server login file:
Step 4: Click the Update button. If the dialog box closes, then the update to the server login file was successful. Click the Refresh icon in the xDB Replication Console tool bar to show the updated Subscription Server node.
Note: Depending upon the database type (Oracle, SQL Server, or Postgres), certain attributes must not be changed. If you have already added subscriptions, you must not change any attribute that alters access to the schema where the subscription tables were created.
Step 1: Make sure the database server that you ultimately wish to save as the subscription database definition is running and accepting client connections.
Step 2: Make sure the subscription server whose node is the parent of the subscription database definition you wish to change is running and has been registered in the xDB Replication Console you are using. See Section 5.3.1 for directions on starting and registering a subscription server.
Step 3: Select the Subscription Database node corresponding to the subscription database definition that you wish to update.
Step 4: From the Subscription menu, choose Subscription Database, and then choose Update Database. Alternatively, click the secondary mouse button on the Subscription Database node and choose Update Database. The Update Database Source dialog box appears.
Step 5: Enter the desired changes. See Step 3 of Section 5.3.2 for the precise meanings of the fields.
Step 6: Click the Test button. If Test Result: Success appears, click the OK button, then click the Save button.
Step 7: Click the Refresh icon in the xDB Replication Console tool bar to show the updated Subscription Database node and any of its subscriptions.
Step 1: Make sure the subscription server whose node is the parent of the subscription you wish to change is running and has been registered in the xDB Replication Console you are using. See Section 5.3.1 for directions on starting and registering a subscription server.
Step 2: Select the Subscription node whose attributes you wish to update.
Step 3: From the Subscription menu, choose Update Subscription. Alternatively, click the secondary mouse button on the Subscription node and choose Update Subscription. The Update Subscription dialog box appears.
Step 4: If the publication server now runs on a host with a different IP address or port number than what is shown in the dialog box, enter the correct information. You must also enter the admin user name and password saved in the xDB Replication Configuration file that resides on the host on which the publication server is running. Click the Update button.
Step 5: If Subscription Updated Successfully appears, click the OK button, otherwise investigate the error and make the necessary corrections.
Step 6: If the publication server with the new network location manages publications subscribed to by other subscriptions, repeat steps 1 through 5 for these other subscriptions.
Step 1: Make sure the publication server whose node is the parent of the publication associated with the subscription you wish to change is running and has been registered in the xDB Replication Console you are using. See Section 5.2.1 for directions on starting and registering a publication server. Make sure the subscription server whose node is the parent of the subscription you wish to change is running and has been registered in the xDB Replication Console you are using. See Section 5.3.1 for directions on starting and registering a subscription server.
Step 2: Select the Subscription node of the subscription on which you wish to enable or disable individual filter rules.
Step 3: Open the Filter Rules tab in any of the following ways:
Step 4: In the Filter Rules tab check or uncheck the boxes to specify the filter rules to enable or disable on the subscription. At most one filter rule may be enabled any given subscription table. Click the Update button.
Step 5: A confirmation box appears presenting a warning message and a recommendation to perform a snapshot replication to any subscription on which you changed the filtering criteria.
Step 6: If you clicked the Ok button in the preceding step, the Filter Rules updated successfully confirmation message appears if the update was successful.
Step 7: It is strongly recommended that a snapshot replication be performed to the subscription that contains tables on which the filtering criteria has changed.
Step 1: Make sure the subscription server whose node is the parent of the subscription you wish to remove is running and has been registered in the xDB Replication Console you are using. See Section 5.3.1 for directions on starting and registering a subscription server.
Step 2: Select the Subscription node of the subscription that you wish to remove.
Step 3: Remove the subscription in any of the following ways:
Step 4: In the Remove Subscription confirmation box, click the Yes button.
Step 1: Make sure the subscription server whose node is the parent of the subscription database definition you wish to remove is running and has been registered in the xDB Replication Console you are using. See Section 5.3.1 for directions on starting and registering a subscription server.
Step 2: Select the Subscription Database node that you wish to remove.
Step 3: From the Subscription menu, choose Subscription Database, then Remove Database. Alternatively, click the secondary mouse button on the Subscription Database node and choose Remove Subscription. The Remove Subscription Database confirmation box appears.
Step 4: In the Remove Subscription Database confirmation box, click the Yes button.

5 Single-Master Replication Operation : 5.5 Managing a Subscription

Table of Contents Previous Next