Replication Server Support for Compressed Data

Replication Server decompresses compressed Adaptive Server data before sending it to the replicate database.

Support for replication of compressed data between an Adaptive Server primary database and an Adaptive Server or heterogeneous replicate database depends on whether the data is in-row or off-row:

Replication Server supports replicating in-row non-LOB compressed data between databases.
Replication Server supports replicating compressed off-row LOB columns between an Adaptive Server primary database and an Adaptive Server or heterogeneous replicate database. Replication Server decompresses LOB data before sending it to a heterogeneous replicate database. Replication Server sends compressed LOB data directly to an Adaptive Server replicate database only if the replicate has the same LOB schema, character set, endianness, version, and page size as the primary Adaptive Server database. Otherwise, Replication Server decompresses LOB data before sending it to the replicate Adaptive Server database.

The Replication Server dsi_do_decompression parameter must be on for Replication Server to decompress LOB data. This parameter is set to on in connection profiles for connecting to a heterogeneous replicate database.

For the LOB data decompression feature, the primary and replicate Replication Servers and the primary Adaptive Server must be version 15.7.1 SP100 or later.