Adaptive Server Data Compression

Replication Server supports the Adaptive Server data compression feature.

Adaptive Server data compression lets you use less storage space for the same amount of data, reduce cache memory consumption, and improve performance by lowering I/O demands. Adaptive Server can compress large object (LOB) datatypes such as text, image, and unitext, and non-LOB datatypes. See the Adaptive Server Enterprise Compression Users Guide.

Adaptive Server stores data in-row or off-row. Adaptive Server stores in-row, data columns that are located contiguous to all other columns for that row. Adaptive Server stores LOB data off-row in other locations because of the size of the data. There is an in-row pointer to the actual location of off-row data.

System Requirements

Adaptive Server – version 15.7 ESD #1 and later for both primary and replicate databases.
Replication Server – version 15.7.1 and later for the primary and replicate Replication Server.

Replication Server Support for Compressed Data
Replication Server decompresses compressed Adaptive Server data before sending it to the replicate database.
Maintaining Data Integrity
To maintain data integrity, use a customized function string to remove undesired data out of the queues if you do not disable replication of off-row compressed LOB columns.

Parent topic: Manage RepAgent and Support Adaptive Server