You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 11-28-2014, 02:25 AM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
suspend connection command in sybase replication server
09-17-2009, 07:21 PM
Post: #1
Quote this message in a reply
suspend connection command in sybase replication server


suspend connection
Description

Suspends a connection to a database.
Syntax

Code:
suspend connection
to data_server.database
[with nowait]
Parameters

data_server

The name of the data server with the database whose connection is to be suspended.

database

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

with nowait

Suspends the connection immediately.

Examples
Example 1

Suspends the connection to the pubs2 database in the SYDNEY_DS data server.

suspend connection to SYDNEY_DS.pubs2

Usage

* Suspending a connection temporarily halts replication activities for the database.
* Connections are suspended so they can be altered with alter connection or so that maintenance can be performed. You can also use suspend connection to control when replicate databases are updated.
* While a connection is suspended, Replication Server holds transactions for the database in stable queues.
* If suspend connection is executed without the with nowait clause, Replication Server attempts to complete any transaction that is in progress. However, the connection to the data server may be suspended before the transaction is completed.
* To reactivate the connection, use resume connection.

Permissions

suspend connection requires “sa” permission.


Find all posts by this user
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
Shy Replication Commands List Required mvsramarao 2 2,624 10-13-2012 09:15 AM
Last Post: sybanva
  Replication server status check commands Kishor 1 4,089 01-05-2011 07:47 AM
Last Post: rajasekharreddytadi
  resume connection command in sybase replication server Nagendra 0 4,510 09-17-2009 07:22 PM
Last Post: Nagendra
  admin health command in sybase replication server Nagendra 0 3,259 09-17-2009 07:19 PM
Last Post: Nagendra
  admin who_is_up command in sybase replication server Nagendra 0 2,040 09-17-2009 07:16 PM
Last Post: Nagendra
  admin who_is_down command in sybase replication server Nagendra 0 2,911 09-17-2009 07:15 PM
Last Post: Nagendra
  Replication Server Commands-Replication server Command followed by description zaadmin 0 4,392 10-20-2008 02:13 PM
Last Post: zaadmin

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication