Enabling Table Metadata Reduction

Enable table metadata reduction for Sybase RepAgent. Replication Server enables the Executor command cache automatically if you enable table metadata reduction in RepAgent.

  1. At the Adaptive Server, execute:
    sp_config_rep_agent database_name, ‘ltl metadata reduction’, 'true'
    where database_name is the primary Adaptive Server database.
    Note: By default, ltl metadata reduction is set to false and RepAgent for Adaptive Server does not enable table metadata reduction.
  2. Restart RepAgent for the change to take effect:
    sp_start_rep_agent database_name
Parent topic: Executor Command Cache