Modify Replicate
Use this page to add or remove participants, change the master replicate server, or change replicate attributes.
With the Modify Replicate action, you can modify a strict master replicate and its participants. A master replicate verifies that replicated tables on different servers have consistent column data types. A strict master replicate also verifies that the replicated tables have identical column names.
Master replicate server
This server group is the basis of the master replicate. You can specify a different server, for example, if a server is being taken out of service.
To specify a different server, click the icon and then select the server from the list.
The master replicate server must be a participant in the replicate.
Create missing tables on target servers
If the master replicate server contains a table that does not exist on a target server, you can create the table automatically by selecting the option Create missing tables on target servers. When you select a table on the master replicate server that does not exist on a target server, the name of the table appears in italics for the target server in the list of tables. When you define the replicate, the table is created on the target server.
The new tables do not automatically include non-primary key indexes, defaults, constraints (including foreign constraints), triggers, or permissions. If the tables require the use of these objects, you must explicitly create the objects.
List of tables
This list displays the tables that are participants in the replicate. Use the list to add or remove participants and to set the participant type and privileges options.
Click the tables in the list to select or clear them. Alternatively, use the Database filter and Table filter to select the tables.
The list displays the following information about the tables:
- Group: The Enterprise Replication (ER) database server group for the table.
- Database: The database that contains the table.
- Owner: The owner of the table.
- Table: The name of the table.
- Type: The participant type. To change the
type, click the icon.
- Primary: The participant both sends and receives replicated data. (Default)
- Receive-only: The participant only receives data from primary participants.
- Privileges: The user whose privileges are
used to apply replicated data. To change the selection, click the
icon.
- Table owner (Default)
- User informix
Database filter
Use this filter to display only the databases that contain the tables that you want to define as participants in the replicate. For Database filter, begin typing the database name. The list expands to display the database on each server and the tables in the database.
Table filter
Use this filter to display only the tables that you want to define as participants in the replicate. For Table filter, begin typing the table name. The list displays for each database only the tables that match.
Select and Clear buttons
Use the Select button to select all the participants specified by the filters. The button is active when not more than one table is selected for each database, and the tables on the different servers have consistent column data types and identical column names.
Click Clear, to clear the selected tables.
Finish and Next buttons
Add and remove participants without changing the options, or proceed to specify the options.
- To add or remove participants without changing the replicate options, click Finish.
- To change the options, click Next.