resume connection

Description

Resumes a suspended connection.

Syntax

resume connection
 to data_server.database
[skip transaction | execute transaction]

Parameters

data_server

The name of the data server that holds the database whose connection is to be resumed.

database

The name of the database whose connection is to be resumed.

skip transaction

instructs Replication Server to resume execution with the second transaction in the connection’s queue. The first transaction is written to the database exceptions log.

execute transaction

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.

Examples

Example 1

Resumes the connection to the pubs2 database in the SYDNEY_DS data server:

resume connection to SYDNEY_DS.pubs2

Usage

Permissions

resume connection requires “sa” permission.

See also

activate subscription, alter connection, assign action, create connection, drop connection, drop subscription, suspend connection