Create a template. Specify the tables to use for the template,
the database and Enterprise Replication (ER) server in which the tables
are located, and the template options.
A template defines a group of master replicates and a
replicate set. A template consists of schema information about a database,
a group of tables, column attributes, and the primary keys that identify
rows.
To define a template:
- On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Replication, and then
click Replicates.
- Click the Templates tab.
- On the Actions menu, click Define
New Template.
- Type a name for the template. The name must be unique and
cannot be the same as a replicate or replicate set name.
- In the Servers list, expand the
server names and databases to display the tables.
Tip: To filter the list, start typing the server name in the Server
filter text box and the database name in the Database
filter text box.
- Select the tables for the template.
- To add all the tables in a database to the list, select the
database in the Tables list, and then click Add.
- To add a specific table, select the table, and then click Add.
- To remove a table from the template, select it, and then click Remove,
or click Remove All.
- To create the template with the default options, click Finish,
or click Next to specify any of the following
options, and then click Finish.
- Conflict Resolution Scope. The default
is transaction.
- Conflict Resolution Rule. The default
is ignore.
- Floating Point Format. The default
is IEEE.
- Activate aborted transaction spooling (ATS).
By default, ATS is not enabled.
- Activate row information spooling (RIS).
By default, RIS is not enabled.
- Fire triggers at destination. By default,
triggers are not fired at the destination table.
- Retain deleted rows. By default, deleted
rows are not retained.
Now you can instantiate the template on database servers
in the ER domain by using the
Realize Template action.
Important: To replicate data in an ER domain based on the replicates
in the template, you must instantiate the template on at least two
servers.