Realizing Templates

After you define a template using the cdr define template command, use the cdr realize template command to instantiate the template on your Enterprise Replication database servers. The cdr realize template command first verifies that the tables on each node match the master definition used to create the template. Then, on each node, it adds the tables defined in the template as participants to master replicates created by the template.

If a table on a server has additional columns to those defined in the template, those columns are not considered part of the replicate.

If a table does not already exist on a server where you realize the template, you can choose to create it, and it is also added to the replicate.

Also, at realization time, you can also choose to synchronize data among all servers.

Verifying Participants without Applying the Template

The --verify option allows you to check that a template's schema information is correct on all servers before actually instantiating the template.

Synchronizing Data Among Database Servers

Use the --syncdatasource option to specify a server to act as the source for data synchronization on all servers where you are realizing the template.

Creating Tables Automatically

The --autocreate option allows you to choose to automatically create tables in the template definition if they do not already exist on a server. (This cannot be done for tables that contain user-defined data types.)

Use the --dbspace option to specify a dbspace for table creation.

Other Options

You can use the --applyasowner option to realize a table by its owner rather than the user informix.

The --extratargetrows option specifies whether to delete, keep, or merge rows found on target servers that are not present on the source server during the synchronization operation.

The --target option defines whether target servers are receive-only (when target servers are defined as receive-only, updates made on those servers are not propagated).

Changing Templates

You cannot update a template. To adjust a template, you must delete it with the cdr delete template command and then re-create it with the cdr define template command.