Setting Configuration Parameters

In the ONCONFIG file for each database server, make sure that the following configuration parameters are set:

• DBSERVERNAME is set to the correct database server.

  If you use both DBSERVERNAME and DBSERVERALIASES, DBSERVERNAME should refer to the TCP connection and not to a shared-memory connection. For information about database server aliases, refer to the IBM Informix Dynamic Server Administrator's Guide.

• CDR_DBSPACE is set to the dbspace for the syscdr database. If not set, the root dbspace is used.
• CDR_QUEUEMEM is set to the maximum amount of memory to be used for the send and receive queues.
• CDR_QHDR_DBSPACE is set to the location of the transaction record dbspace.

  For more information, see Transaction Record dbspace.

• CDR_QDATA_SBSPACE is set to the location of the row data sbspace.

  If the CDR_QDATA_SBSPACE configuration parameter is not set in ONCONFIG or the sbspace name specified by CDR_QDATA_SBSPACE is invalid, Enterprise Replication fails to define the server.

  For more information, see Row Data sbspaces.

• CDR_SERIAL is set to generate non-overlapping (unique) values for SERIAL columns across all database servers in the replication environment.

  For more information, see SERIAL Data Types and Primary Keys.

If you want to suppress certain Datasync error and warning codes from appearing in ATS and RIS files, you can set the CDR_SUPPRESS_ATSRISWARN configuration parameter. See CDR_SUPPRESS_ATSRISWARN Configuration Parameter for more information.

If you want to encrypt network communications, make sure that the following configuration parameters are set in the ONCONFIG file for each database server:

• ENCRYPT_CDR is set to 1 or 2 to enable encryption. The default value is 0, which prevents encryption.
• ENCRYPT_CIPHERS specifies which ciphers and cipher modes are used for encryption.
• ENCRYPT_MAC controls the level of Message Authentication Code (MAC) used to ensure message integrity.
• ENCRYPT_MACFILE is set to the full path and filenames of the MAC files.
• ENCRYPT_SWITCH is set to the number of minutes between automatic renegotiations of ciphers and keys. (The cipher is the encryption methodology. The secret key is the key used to build the encrypted data using the cipher.)

These configuration parameters are documented in Appendix B. Configuration Parameter and Environment Variable Reference.