Set the Save Interval for Connections

Execute the alter connection command with the save_interval parameter at the Replication Server to set the save interval for a database connection.

For example, to set Replication Server SYDNEY_RS to save for one hour any messages destined for its replicate data server SYDNEY_DS, enter:

alter connection to SYDNEY_DS.pubs2
    set save_interval to '60'

By default, the save_interval is set to 0 (minutes).

You can also configure the save intervals for the DSI queue and the materialization queue for a logical connection.