Realize Template

Use this page to instantiate a template on Enterprise Replication (ER) servers.

Prerequisite: Before you can instantiate a template, you must define the template. On the Actions menu, click Define New Template.

Important: To replicate data in an ER domain based on the replicates in a template, the template must be instantiated on at least two servers.

Replicate set name

The name of the replicate set that is created when the template is instantiated.

Available Servers

Select the servers on which to instantiate the template, or select All servers. The list displays the servers in the domain on which the template has not been instantiated.

Server filter: To filter the list, start typing the server name.

Next or Finish

To instantiate the template on the selected servers with the default options, click Finish.
To specify the options, click Next.

Options

Specify any of these options.

Table 1. Options
Option	Description
Create missing tables on the target servers	If the template contains a table that does not exist on the target servers, create the table automatically. Available dbspaces: Specify the dbspace for the created tables. (Default) The dbspace for the created tables is set to the same dbspace as the database. Note: 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 create them.
Apply replicated data with table owner privileges	Specify that the owner of the source table is the owner of the tables that are created when the template is realized. (Default) The tables are owned by the user informix.
Set the target servers to receive only	Specify that the target servers only receive data from the primary participants. (Default) The target servers both send and receive replicated data. To make the target servers receive-only servers and synchronize the data on the target servers with a source serve, first instantiate the template on the source server. Then instantiate the template on the target servers with this option and the option to synchronize the data with the source server selected.
Synchronize the data with this source server	Specify a server to act as the source for data synchronization on the servers that the template is instantiated on.
Specify how to handle rows on target servers that are not on the reference server:	Specify how to handle rows on the target servers that are not on the source server. Delete: Delete the extra rows from the target servers. Keep: Keep the extra rows on the target servers. Merge: Keep the extra rows on the target servers and replicate them to the source server.