Managing database connections

Database connections are identified by the form ds.db, where:

Table 3-3 lists the ASE Replicator procedures you can use to manage database connections.

Table 3-3: ASE Replicator connection management procedures

Procedure

Description

sp_addprimaryconn

Defines a new primary database connection

sp_addreplicateconn

Defines a new replicate database connection

sp_configprimaryconn

Sets or returns information about primary connection configuration parameters

sp_configreplicateconn

Sets or returns information about replicate connection configuration parameters

sp_dropprimaryconn

Deletes an existing primary database connection

sp_dropreplicateconn

Deletes an existing replicate database connection

sp_helpconn

Returns information about database connections

sp_helpprimaryconn

Returns information about primary database connections

sp_helprep

Returns statistics or status information for the replication system, connections, and subscriptions

sp_helpreplicateconn

Returns information about replicate database connections

sp_resumeprimaryconn

Resumes suspended primary database connections

sp_resumereplicateconn

Resumes suspended replicate database connections

sp_suspendprimaryconn

Suspends primary database connections

sp_suspendreplicateconn

Suspends replicate database connections