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.
Sequence Objects

Sequence Objects

In bi-directional Enterprise Replication, if you replicate tables using sequence objects for update, insert, or delete operations, the same sequence values might be generated on different servers at the same time, leading to conflicts.

To avoid this problem, define sequence objects on each server so that the ranges of generated sequence values are distinct. For more information about the CREATE SEQUENCE and ALTER SEQUENCE statements of SQL, see the HCL OneDB™ Guide to SQL: Syntax.