Replication Server copies execution of truncate table to warm standby databases. The active and standby databases must be Adaptive Server version 11.5 or later to support this feature.
To enable or disable replication of truncate table, log in to the source Replication Server and enter:
alter logical connection
to logical_ds.logical_db
set send_truncate_table to {on | off}
If your warm standby application was created before you upgraded or installed Replication Server version 11.5 or later, Replication Server does not copy truncate table to the standby database unless you enable this feature with alter logical connection. To preserve compatibility with existing warm standby applications, the default setting is “off.”
If your warm standby application was created after you upgraded or installed Replication Server version 11.5 or later, Replication Server automatically copies truncate table to the standby database unless you disable this feature with alter logical connection. The default setting is “on.”
