Replication Definition Change Process

If you are making many changes to the RSSD, such as creating, altering, or dropping replication definitions, or customizing function strings, Sybase recommends that before you start the replication definition change process, disable sts_full_cache for rs_objects, rs_columns, and rs_objfunctions, and then set sts_full_cache for these tables to their original values after the replication definition change process.

Tip: Execute the Adaptive Server update statistics command on the RSSD tables periodically if there are many RSSD changes. For replication definition change requests, such as to create, alter, or drop replication definitions, the affected tables are rs_objects, rs_columns, and rs_objfunctions. For function string change requests, such as to create, alter, or drop function strings, the affected tables are rs_funcstrings and rs_systext.

To disable sts_full_cache_system_table_name where system_table_name is the name of the table:

configure replication server
set sts_full_cache_system_table_name to ‘off

See Replication Server Administration Guide Volume 1 > Manage Replicated Tables > Modify Replication Definitions > Alter Replication Definitions > Replication Definition Change Request Process.