After you have changed the attributes of a database connection, you can resume activity on the connection either in Sybase Central or by using the resume connection command.
resume connection to data_server.database [skip [n] transaction | execute transaction]
When the connection is resumed, Replication Server retrieves rows from the rs_lastcommit system table so that it can find the correct place in the transaction stream to begin submitting transactions.
The optional skip [n] transaction clause instructs Replication Server skip a specified number of transactions in the connection queue before resuming the connection. The first n transactions are written to the exceptions log.
The skip [n] transaction clause is necessary if the first n transactions cause Replication Server to suspend the connection and the cause of the failure cannot be corrected. For example, the transaction may have produced a data server error that is assigned the retry_stop or stop_replication error action. Or, perhaps it was necessary to use suspend connection and the with nowait clause to manually interrupt the transaction.
The optional execute transaction clause instructs Replication Server to execute the first transaction in the connection’s queue. Use this clause only when a system transaction has failed to execute. See Replication Server Administration Guide Volume 2 > Errors and Exceptions Handling > Duplicate Detection for System Transactions for information about error handling for system transactions.