Resumes a suspended connection.
resume connection to <data_server>.<database> [skip [<n>] transaction | execute transaction | skip to resync marker]
The name of the data server that holds the database whose connection is to be resumed.
The name of the database whose connection is to be resumed.
Instructs Replication Server to skip a specified number of transactions in the connection queue before resuming the connection. The skipped transactions are written to the database exceptions log. If you want to write the skipped transactions to either the Replication Server log or the alternative log file specified by the sysadmin dump_file command, you must enable the dsi_log_cmds parameter. The maximum number of transactions that resume connection can skip is the number of committed unread transactions in the Stable Queue Transaction (SQT).
If SQT transactions are less than the specified value to skip, Replication Server does not wait to receive subsequent transactions. Thus, Replication Server prevents from sending large number of transactions to be skipped than what is available in SQT.
If <n> is not specified, Replication Server resumes execution with the second transaction in the connection’s queue.
Overrides the Replication Server restriction against the application of system transactions after a DSI startup if the system transaction is the first transaction in the DSI queue.
Instructs Replication Server to skip transactions in the DSI outbound queue for the specified replicate database until Replication Server receives and acknowledges a dump database marker sent by Replication Agent. Replication Server skips processing of records in the outbound queue since the data in the replicate database is expected to be replaced with the dump contents.
Resumes the connection to the <pubs2> database in the SYDNEY_DS data server:
resume connection to SYDNEY_DS.pubs2
resume connection to SYDNEY_DS.pubs2 skip 2 transaction
sysadmin dump_file SYDNEY_RS.log resume connection to SYDNEY_DS.pubs2 skip 2 transaction sysadmin dump_file
Instruct Replication Server to remove data from the replicate database outbound queue and wait for a resync marker from the primary database Replication Agent:
resume connection to SYDNEY_DS.pubs2 skip to resync marker
Resuming a connection allows replication activities for the suspended database to begin again.
Suspend connections so you can alter them with alter connection or perform maintenance on the suspended database. Connections are also suspended during subscription materialization or dematerialization.
Replication Server can suspend a database connection because of an error.
resume connection is also used to resume a connection suspended because of an error.
If you determine that the system transaction was executed, use the skip transaction clause.
E. 1998/02/16 14:43:49. ERROR #5152 DSI (206 hookip01.rdb1) - dsisched.c (2196) There is a system transaction whose state is not known. DSI will be shut down.
Determine whether the database has executed this transaction and use skip transaction or execute transaction as appropriate.
When you set skip to resync, Replication Server does not log the transactions that are skipped in the Replication Server log or in the database exceptions log. Replication Server logs transactions that are skipped when you set skip [n] transaction.
If after executing resume connection with skip to resync marker, Replication Agent does not issue the correct marker or you issue the marker against the wrong connection, or for other reasons the DSI connection is not expected to process the resync database marker, you can resume normal replication processing without waiting for the resync database marker by executing suspend connection, and then resume connection without the skip to resync option.
If you execute resume connection with the skip to resync marker option on the wrong connection, data on the replicate database becomes unsynchronized.
resume connection requires “sa” permission.