Table of Contents Previous Next


7 Common Operations : 7.6 Managing a Publication

Step 1: The publication 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.2.1 for directions on starting the publication server.
Step 2: Click the secondary mouse button on the Publication Server node and choose Update. The Update Publication 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 Publication Server node.
Note: This section applies only to single-master replication systems.
Step 1: The publication server whose metadata you want to change must be running. See Step 1 of Section 5.2.1 for directions on starting the publication server.
Step 2: Click the secondary mouse button on the Publication Server node and choose Update Subscription Servers. The Update Subscription Servers dialog box appears.
Note: If the error message box reappears, click the OK button and repeat Step 2.
Step 3: Enter the new network location for each subscription server in the list whose network location has changed.
Step 4: Click the Update button. If the dialog box closes, then the update to the publication server’s metadata was successful.
Step 5: If the subscription server with the new network location manages subscriptions associated with publications in other publication servers, repeat steps 1 through 4 for these other publication servers.
Note: Depending upon the database type (Oracle, SQL Server, or Postgres), certain attributes must not be changed. You must not change any attribute that alters access to the schema where the control schema objects were created when you originally added this publication database definition. See Section 5.2.4 for the location of the control schema objects.
Step 1: Make sure the database server that you ultimately wish to save as the publication database definition is running and accepting client connections.
Step 2: Make sure the publication server whose node is the parent of the publication database definition 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.
Step 3: Select the Publication Database node corresponding to the publication database definition that you wish to update.
Step 4: From the Publication menu, choose Publication Database, and then choose Update Database. Alternatively, click the secondary mouse button on the Publication 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.2.2 for the precise meanings of the fields for a single-master replication system. See sections 6.2.2 and 6.3 for a multi-master replication system.
Step 6: Click the Test button. If Test Result: Success appears, click the OK button, then click the Save button.
Step 7: Restart the publication server. See Section 5.2.1 for directions on restarting the publication server.
Step 8: Click the Refresh icon in the xDB Replication Console tool bar to show the updated Publication Database node and any of its publications.
Step 1: Make sure the publication server whose node is the parent of the publication 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.
Step 2 (For SMR only): Select the Publication node of the publication to which you wish to add tables.
Step 2 (For MMR only): Select the Publication node under the Publication Database node representing the master definition node.
Step 3: Open the Add Tables dialog box in any of the following ways:
Step 4: Fill in the following fields in the Add Tables tab of the Add Tables dialog box:
Add. Check the boxes next to the table names from the Available Tables list that are to be added to the publication. If the publication is a snapshot-only publication, then views would appear in the Available Tables list as well. The Available Tables list contains only tables and views that are not already members of other publications under the same Publication Database node. Alternatively or in addition, click the Use Wildcard Selection button to use wildcard pattern matching for selecting tables to be added to the publication.
Select All. Check this box if you want to include all tables and views in the Available Tables list in the publication.
Use Wildcard Selection. Click this button to use the wildcard selector to choose tables for the publication. See Section 7.1 for information on the wildcard selector.
Step 5 (Optional): If you want to filter the rows of the publication tables or views, click the Table Filters tab. Define filter rules by entering a unique, descriptive filter name and an appropriate SQL WHERE clause in the Filter dialog box to select the rows you want to replicate.
For a single-master replication system, see Section 5.2.3 for information on defining table filters on a publication table.
Step 6 (For SMR only): Click the Add Tables button. If Publication Updated Successfully appears, click the OK button, otherwise investigate the error and make the necessary corrections.
Step 6 (For MMR only): Click the Add Tables button. The Data Sync Check dialog box appears warning you that synchronization replication is performed before the table is added.
Step 7: The replication tree appears as follows with the newly added table under the Publication node. Click the Refresh icon. The newly added table appears under the Subscription nodes of a single-master replication system or the additional master nodes of a multi-master replication system.
Step 8 (For MMR only): If you want to modify or see the default conflict resolution options assigned to the newly added table, follow the directions in Section 6.8.
Step 9 (Optional): If you defined table filters on the newly added table, and you wish to use these filters on any subscriptions or master nodes, you must enable the filters on the table within the desired subscriptions or master nodes.
For a single-master replication system, see Section 5.5.4 for directions on enabling table filters on a subscription.
For a multi-master replication system, see Section 6.9 for directions on enabling table filters on a master node.
pp_xdb_repsvr_ug_erdiag
In the preceding entity relationship diagram, the emp table has a foreign key constraint referencing the dept table, and the jobhist table has two foreign key constraints. One constraint references the emp table and the other references the dept table.
Remove the jobhist table only.
Remove both the jobhist table and the emp table.
Step 1: Make sure the publication server whose node is the parent of the publication 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.
Step 2 (For SMR only): Select the Publication node of the publication from which you wish to remove tables.
Step 2 (For MMR only): Select the Publication node under the Publication Database node representing the master definition node.
Step 3: Open the Remove Tables dialog box in any of the following ways:
Step 4: Use the Remove Tables dialog box as follows:
Remove. Check the boxes next to the table names from the Available Tables list that are to be removed from the publication. If the publication is a snapshot-only publication, then views would appear in the Available Tables list as well. Alternatively or in addition, click the Use Wildcard Selection button to use wildcard pattern matching for selecting tables to be removed from the publication.
Use Wildcard Selection. Click this button to use the wildcard selector to choose tables to remove from the publication. See Section 7.1 for information on the wildcard selector.
Step 5: Click the Remove button, then click the Yes button of the confirmation box.
Step 6: Click the OK button in response to Tables Removed Successfully.
Note: See Section 2.2.12.3 for table setup requirements for a log-based replication system as well as general restrictions on the use of table filters.
See Section 5.2.3 for information on using table filters in a single-master replication system and Section 6.2.3 for a multi-master replication system.
Step 1: Make sure the publication server whose node is the parent of the publication 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.
Step 2 (For SMR only): Select the Publication node of the publication in which you wish to update the set of available table filters.
Step 2 (For MMR only): Select the Publication node under the Publication Database node representing the master definition node.
Step 3: Open the Update Filters dialog box in any of the following ways:
Step 4: The set of all available filter rules defined in the publication are listed under the Table Filters tab.
Step 5: A confirmation box appears presenting a warning message and a recommendation to perform a snapshot replication to any subscription or master node on which you intend to enable the change in filtering criteria.
Step 6: You may selectively enable any new filter rules to the corresponding tables of the associated subscriptions or master nodes. See Section 5.5.4 for information on enabling table filters on a subscription. See Section 6.9 for enabling table filters on a master node.
Once a publication is created, do not directly change the definitions of the tables belonging to the publication. Doing so may cause a failure during the replication process. Examples of table definitions that must not be altered include:
Note: Do not change the triggers generated by xDB Replication Server. If it becomes necessary to regenerate the triggers, you must remove the associated publication and then recreate the publication.
Remove the publication. See Section 7.6.6 for directions to remove a publication.
Re-add the publication. See Section 5.2.3 for directions to add a publication.
Re-add the subscription. See Section 5.3.3 for directions to add a subscription.
Remove the publication. See Section 7.6.6 for directions to remove a publication.
Re-add the publication. See Section 6.2.3 for directions to add a publication.
Re-add additional master nodes. See Section 6.3 for directions to add an additional master node. When creating a master node, uncheck the Replicate Publication Schema check box if you have already created the table definitions on all master nodes. Check the Replicate Publication Schema check box if you want to propagate the table definitions from the master definition node to all other master nodes. A snapshot reloads the master node tables from the master definition node.
Note: This validation feature is only available for publications using the trigger-based method of synchronization replication. This validation feature is not available for publications using the log-based method of synchronization replication.
The validation operation described here and in Section 7.6.5.2 can check for the following types of table modifications:
Note: In a multi-master replication system, publication tables in only the master definition node are validated. The validation operation does not check if table definitions have changed in other master nodes.
Step 1: Make sure the publication server whose node is the parent of the publication you wish to validate 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.
Step 2 (For SMR only): Select the Publication node of the publication you want to validate.
Step 2 (For MMR only): Select the Publication node under the Publication Database node representing the master definition node.
Step 3: From the Publication menu, choose Validate Publication. Alternatively, click the secondary mouse button on the Publication node and choose Validate Publication.
Step 4: If All Schema of Published Tables in Publication 'publication_name' Are Up-To-Date appears, click the OK button. If an error appears, determine which tables were changed and what changes were made to the table definitions. These issues need to be resolved on a case by case basis as discussed earlier in this section.
Note: This validation feature is only available for publications using the trigger-based method of synchronization replication. This validation feature is not available for publications using the log-based method of synchronization replication.
Note: In a multi-master replication system, publication tables in only the master definition node are validated. The validation operation does not check if table definitions have changed in other master nodes.
Step 1: Make sure the publication server whose node is the parent of the publications you wish to validate 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.
Step 2 (For SMR only): Select the Publication Database node under which you want to validate all publications.
Step 2 (For MMR only): Select the Publication Database node representing the master definition node.
Step 3: From the Publication menu, choose Validate All Publications. Alternatively, click the secondary mouse button on the Publication Database node and choose Validate All Publications.
Step 4: If there were no modified tables, click the OK button.
Step 1: Make sure the publication server whose node is the parent of the publication you wish to remove 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.
Step 2 (For SMR only): Select the Publication node of the publication that you wish to remove.
Step 2 (For MMR only): Select the Publication node under the Publication Database node representing the master definition node.
Step 3: Remove the publication in any of the following ways:
Step 4: In the Remove Publication confirmation box, click the Yes button.
For Oracle and SQL Server: All metadata database objects under the publication database user’s schema are deleted.
For Postgres only: The schema _edb_replicator_pub and all of its database objects are deleted from the publication database.
Step 1: Make sure the publication server whose node is the parent of the publication database definition you wish to remove 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.
Step 2: Select the Publication Database node that you wish to remove.
Step 3: From the Publication menu, choose Publication Database, then Remove Database. Alternatively, click the secondary mouse button on the Publication Database node and choose Remove Database. The Remove Publication Database confirmation box appears.
Step 4: In the Remove Publication Database confirmation box, click the Yes button.

7 Common Operations : 7.6 Managing a Publication

Table of Contents Previous Next