CDR_SERIAL Configuration Parameter

default value

0,0

units

delta, offset

range of values

0,0 disable control of serial column value generation

>0,>0 enable control of serial column value generation

takes effect

when Enterprise Replication is initialized

The CDR_SERIAL configuration parameter enables control over generating values for serial and SERIAL8 columns in tables defined for replication. This is useful for generating unique serial column primary keys in an Enterprise Replication environment.

The format is:

CDR_SERIAL delta,offset

where:

delta

determines the incremental size of the serial column values

offset

determines the specific number within the delta that will be generated.

Example CDR_SERIAL Value	Resulting Value for the SERIAL Column
CDR_SERIAL 100,1	1, 101, 201, 301, and so on
CDR_SERIAL 200,2	2, 202, 402, 602, and so on

You should set the delta to greater than the expected number of servers within your enterprise and make sure the offset is unique on each server.

When you set CDR_SERIAL, only tables that are marked as the source of a replicate use this method of serial column generation. By default, CDR_SERIAL is set to 0 to disable control over generating SERIAL and SERIAL8 values.

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