RepAgent Scanner Schema Cache Memory Management

With Adaptive Server 15.7 SP100, you can optimize Adaptive Server RepAgent memory consumption and improve RepAgent performance by setting the maximum amount of memory that each RepAgent scanner thread can use to store object schema required for replication.

Use the max schema cache per scanner parameter of the Adaptive Server RepAgent sp_config_rep_agent system procedure to allow each RepAgent scanner thread to store and process more transactions, therefore improving replication performance. If the cache fills up, it flushes out older object schema to make space for newer object schema.

See Setting Maximum Scanner Schema Cache Size in the Replication Server Administration Guide Vol 2.

Removal of schema cache grow factor Parameter

max schema cache per scanner replaces schema cache grow factor as a better parameter for tuning RepAgent schema cache memory management.