Jump to main content
Product Documentation
Customer Support
HCL OneDB 2.0.1
What's new in
HCL OneDB™
2.0.1
Getting Started
Installing
Administering
Migrating and upgrading
Data warehousing
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Troubleshooting
HCL OneDB™
Search
Home
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise Replication
The
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.
Appendixes
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
System administration
These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning
HCL OneDB™
database servers.
Backup and Restore Guide
The
HCL OneDB™ Backup and Restore Guide
describes how to use the
HCL® OneDB®
ON-Bar
utility to back up and restore database server data.
This will enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
Enterprise Replication
The
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 Replication
Before 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.
Setting up and managing Enterprise Replication
After you design your replication system, you define it and start replication.
Push data feature
Loopback replication
Appendixes
The cdr utility
You use the
cdr
utility to configure and control
Enterprise Replication
from the command line on your UNIX™ or Windows™ operating system.
Enterprise Replication
configuration parameter and environment variable reference
You can use configuration parameters and environment variables to configure the behavior of
Enterprise Replication
.
Grid routines
Grid routines are used to create and maintain the grid and to administer servers in the grid by propagating commands from a source server to all other servers in the grid.
Enterprise Replication routines
Enterprise Replication routines used to control if a replicated transaction is recaptured.
onstat -g commands for Enterprise Replication
You can monitor and debug Enterprise Replication activity using
onstat -g
commands.
syscdr Tables
These tables in the
syscdr
database contain progress information about consistency checking and synchronization operations.
SMI Table Reference
The system-monitoring interface (SMI) tables in the
sysmaster
database provide information about the state of the database server. Enterprise Replication uses the following SMI tables.
Replication Examples
This appendix contains simple examples of replication using the command-line utility (CLU).
SQLHOSTS Registry Key (Windows™)
In an Enterprise Replication environment, you manage connectivity information about
Windows™
operating systems with the SQLHOST registry key.
Data sync warning and error messages
Data sync warning and error messages describe problems with replicated transactions.
Appendixes
The cdr utility
You use the
cdr
utility to configure and control
Enterprise Replication
from the command line on your UNIX™ or Windows™ operating system.
Enterprise Replication configuration parameter and environment variable reference
You can use configuration parameters and environment variables to configure the behavior of
Enterprise Replication
.
Grid routines
Grid routines are used to create and maintain the grid and to administer servers in the grid by propagating commands from a source server to all other servers in the grid.
Enterprise Replication routines
Enterprise Replication routines used to control if a replicated transaction is recaptured.
onstat -g commands for Enterprise Replication
You can monitor and debug Enterprise Replication activity using
onstat -g
commands.
syscdr Tables
These tables in the
syscdr
database contain progress information about consistency checking and synchronization operations.
SMI Tables for Enterprise Replication Reference
The system-monitoring interface (SMI) tables in the
sysmaster
database provide information about the state of the database server. Enterprise Replication uses the following SMI tables.
Replication Examples
This appendix contains simple examples of replication using the command-line utility (CLU).
SQLHOSTS Registry Key (Windows)
In an Enterprise Replication environment, you manage connectivity information about
Windows™
operating systems with the SQLHOST registry key.
Data sync warning and error messages
Data sync warning and error messages describe problems with replicated transactions.
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.