Replication Server Tasks and Responsibilities

Use the Replication Server Tasks and Responsibilities table to assign tasks and roles to maintain the replication system.

Replication Server Tasks and Responsibilities

Task

References

Roles

Installing Replication Server and initial configuration.

Installation and configuration guides

replication system administrator (RSA), database administrator (DBA)

Starting up and shutting down Replication Server.

Manage a Replication System

RSA

Quiescing Replication Server.

Manage a Replication System

RSA, DBA

Adding login names, database users, and administering appropriate permissions.

Manage Replication Server Security

RSA, DBA

Monitoring Replication Server.

Manage a Replication System

RSA

Configuring Replication Server.

Manage a Replication System

RSA

Adding replicated tables and stored procedures or changing table schemas.

  • Creating and modifying replicated tables and stored procedures.

  • Creating and modifying table and function replication definitions.

  • Creating and materializing subscriptions at replicate sites.

RSA, DBA

Defining data server function-string classes and function strings.

Replication Server Administration Guide Volume 2 > Customize Database Operations

RSA, DBA

Maintaining routes.

  • Creating and modifying routes.

Manage Routes

RSA

Maintaining and monitoring database connections.

  • Suspending and resuming connections.

Manage Database Connections

RSA

Creating a warm standby application.

Replication Server Administration Guide Volume 2 > Manage Warm Standby Applications

RSA, DBA

Localizing Replication Server.

Replication Server Design Guide

RSA

Adding a primary or replicate database connection.

Manage Database Connections

RSA, DBA

Adding or removing a Replication Server.

Manage a Replication System

RSA

Processing rejected transactions.

Replication Server Administration Guide Volume 2 > Handle Errors and Exceptions.

RSA, DBA

Administering local data server.

  • Suspending or resuming data server.

Adaptive Server or local server documentation.

DBA

Managing the RSSD.

Manage a Replication System

RSA, DBA

Managing Embedded Replication Server System Database (ERSSD).

Manage a Replication System

RSA, DBA

Creating, deleting, and modifying databases for replication.

Adaptive Server or local server documentation.

DBA

Setting up database user login names and passwords.

Adaptive Server or local server documentation.

DBA

Performing regular backups.

Replication Server Administration Guide Volume 2 > Verify and Monitor Replication Server.

DBA

Applying database recovery procedures.

Replication Server Administration Guide Volume 2 > Replication System Recovery

RSA, DBA

Reconciling database inconsistencies.

Manage Subscriptions

RSA, DBA

Auditing user actions performed on Replication Server. Command Auditing

RSA