CDRSITES_92X Environment Variable

Works around a malfunction in version reporting for 9.21 or 9.20 servers.

units
cdrIDs, which are the unique identifiers for the database server in the Options field of the SQLHOSTS file ( i =unique_ID)
range of values
positive numbers
takes effect
when Enterprise Replication is initialized and the CDR_ENV configuration parameter has a value for CDRSITES_92X in the ONCONFIG file, or immediately for the following actions:
  • Adding a value using the cdr add onconfig command
  • Removing a value using the cdr remove onconfig command
  • Changing a value using the cdr change onconfig command

In mixed-version Enterprise Replication environments that involve 9.21 or 9.20 servers, the NIF does not properly report its version when it responds to a new server. When a new server sends an initial protocol message to a sync server, the sync server, instead of properly giving its version, gives back the version of the new server. If a 10.0/9.40/9.30 server tries to synchronize with a 9.21 or 9.20 server, the older server responds to the 10.0, 9.40, or 9.30 server that it is a 10.0, 9.40, or 9.30 server and will subsequently fail.

To prevent this malfunction, if you have Version 9.21 or 9.20 servers in your Enterprise Replication environment, set the CDRSITES_92X environment variable

Note: You can only set the CDRSITES_92X environment variable by using the CDR_ENV configuration parameter. You cannot set CDRSITES_92X as a standard environment variable.

For example, suppose that you have 5 database servers, Version 9.21 or 9.20 whose cdrID values range from 2 through 10 (cdrIDs = 2, 3, 8, 9, and 10).

If you upgrade database server cdrID 8 to Version 10.0, 9.40, or 9.30, you must set the CDRSITES_92X environment variable for the other server cdrIDs by setting the CDR_ENV configuration parameter in the ONCONFIG file before bringing the Version 10.0, 9.40, or 9.30 database server online:

CDR_ENV CDRSITES_92x=2,3,9,10