Comparisons Against Compressed Tables Fail

Problem: Comparisons fail repeatedly when a compareset points to one or more compressed tables created in Adaptive Server 15.7.

Possible cause: A defect in the Adaptive Server 15.7 compression memory pool that causes the Adaptive Server to enter an error state from which it cannot recover without a restart. The defect occurs when Adaptive Server fails to allocate compression memory. Check the Adaptive Server log for errors.

Either:

Use comparer_max_concurrent_threads and comparer_max_concurrent_threads to decrease the number of DA threads that concurrently select from Adaptive Server 15.7, or,
Increase the size of Adaptive Server compression memory by editing these configuration parameters:
- compression memory size
- compression info pool size
The amount by which these parameters must be increased varies.

See the alphabetical listing of configuration parameters in the Adaptive Server Enterprise System Administration Guide: Volume 1.