CDRSITES_731 Environment Variable

Works around a malfunction in version reporting for post-7.3x, 7.20x, or 7.24x version 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_731 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 post 7.3x, 7.20x, or 7.24x 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, or 9.30 server tries to synchronize with a 7.3x, 7.20x, or 7.24x 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 7.3x, 7.20x, or 7.24x servers in your Enterprise Replication environment, set the CDRSITES_731 environment variable with the CDR_ENV configuration parameter for these servers.

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

For example, suppose that you have 5 database servers, Version 7x servers whose cdrID values range from 1 through 7 (cdrID = 1, 4, 5, 6, and 7).

If you upgrade database server cdrID 6 to Version 10.0, 9.40, or 9.30, you must set the CDRSITES_731 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_731=1,4,5,7

Copyright© 2018 HCL Technologies Limited