Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Planning and designing for Enterprise ReplicationBefore you set up your replication system, plan how to include Enterprise Replication into your database server environment, design your database schema by following Enterprise Replication requirements, and then design your replication system between database servers.
Schema design for Enterprise ReplicationWhen you design the database and tables for replication, you must follow the requirements and restrictions for Enterprise Replication.
Replication and data typesEnterprise Replication supports built-in data types and user-defined data types, including row types and collection types.
Serial data types and replication keysYou can use a serial data type as a replication key, but you must ensure that the values are unique across all replication servers.

Serial data types and replication keys

You can use a serial data type as a replication key, but you must ensure that the values are unique across all replication servers.

If you plan to use serial data types (SERIAL, SERIAL8, or BIGSERIAL) as the replication key for a table, the same serial value might be generated on two servers at the same time. Use the CDR_SERIAL configuration parameter to generate non-overlapping values for serial columns across all database servers in your replication environment. Set CDR_SERIAL in the onconfig file for each primary source database server in the replication system.

You do not need to set the CDR_SERIAL configuration parameter if your replication key has multiple columns and the other columns identify the server on which each row is created.