70 Informix Dynamic Server V10: Superior Data Replication for High Availability and Distribution
configuration parameters in the onconfig file (and the values used in the example
systems) include those identified in Table 6-1.
Table 6-1 Configuration parameters
Each instance in the example has a unique set of values for CDR_SERIAL. That
allows the use of the SERIAL type in a way that avoids conflicts. If that change to
the sequence of generated numbers cannot be made for some reason, then the
conflict resolution scheme
must be able to handle the problem.
The CDR_QUEUEMEM, CDR_QHDR_DBSPACE, and
CDR_QDATA_SBSPACE parameters define the space for the queue headers
and data held or received by the replication threads. Each of these needs to be
defined using the onspaces command before replication can be started. See the
IBM Informix Enterprise Replication Guide, G251-1254, for advice on how to
determine a good size for this dbspace and smart blobspace.
The CDR_DBSPACE is the dbspace in which the syscdr database is created.
This may be an existing space or a space that is added for this purpose. In the
example, we chose to create a dbspace specifically for this database.
The CDR_EVALTHREADS defines how many additional threads will be used in
each CPU virtual processor (VP) to evaluate what data from each SQL statement
should be held for replications. The choice of number here depends on the
volume of work. For the example, we chose to use only a single thread because
the workload was very light.
Parameter Value Description
CDR_EVALTHREADS 2 # evaluator threads (per-cpu-vp,
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Max amount of memory for any CDR
CDR_NIFCOMPRESS 0 # Link level compression (-1= never, 0=
none, 9= max)
CDR_SERIAL 1000,1 # Serial Column Sequence
CDR_DBSPACE cdrspc # dbspace for syscdr database
CDR_QHDR_DBSPACE cdrspc # CDR queue dbspace (default same as
CDR_QDATA_SBSPACE cdrqueues # List of CDR queue smart blob spaces