Manage Database Connections

Managing database connections includes preparing databases for replication, creating connections to the databases, and configuring the connections for optimal replication performance.

• Prepare Databases for Replication
  Before you can add databases to a replication system, you need to prepare them so that Replication Server can distribute the primary data and maintain the replicated data stored in them.
• Manage the Maintenance User
  To update replicated data, Replication Server logs in to the data server as the maintenance user. The database owner or the system administrator must grant to the maintenance user the permissions required to insert, delete, and update rows in replicated tables and to execute replicated stored procedures.
• Create Database Connections
  A connection defines a database to the Replication Server. A Replication Server is designated to manage the database and, if it is a replicate database, to distribute transactions to the database.
• Altering Database Connections
  Use Sybase Central or alter connection to change the attributes of a database connection at the Replication Server where the connection was created.
• Drop Database Connections
  To remove a database from the replication system, use Sybase Central or execute drop connection.
• Monitor Database Connections
  Use Sybase Central, or stored procedures and RCL commands to monitor database connections.