Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe describes the concepts of data replication using Informix® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Defining Replication Servers, Replicates, Participants, and Replicate SetsThese topics describe the steps defining and starting Enterprise Replication.
Set up replication through templatesEnterprise Replication provides templates to allow easy setup and deployment of replication for clients with large numbers of tables to replicate. A template uses schema information about a database, a group of tables, columns, and replication keys to define a group of master replicates and a replicate set.
Realizing Templates
Create tables automaticallyYou automatically create tables in the template definition if they do not exist on a server.

Create tables automatically

You automatically create tables in the template definition if they do not exist on a server.

Include the --autocreate option in the cdr realize template command to automatically create tables. You cannot use the --autocreate option for tables that contain user-defined data types.

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

Note: Tables that are created by --autocreate option do not automatically include non-replicate key indexes, defaults, constraints (including foreign constraints), triggers, or permissions. You must manually create these objects.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.