Replication Server tasks and responsibilities

Table 1-1 lists the tasks required to maintain the replication system.

Table 1-1: Replication Server tasks and responsibilities

Task and reference

Roles

Installing Replication Server. Refer to the Replication Server installation and configuration guides for your platform.

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

Starting up and shutting down Replication Server. See Chapter 4, “Managing a Replication System.”

RSA

Quiescing Replication Server. See Chapter 4, “Managing a Replication System.”

RSA, DBA

Adding login names, database users, and administering appropriate permissions. See Chapter 8, “Managing Replication Server Security.”

RSA, DBA

Monitoring Replication Server. See Chapter 4, “Managing a Replication System.”

RSA

Configuring Replication Server. See Chapter 4, “Managing 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.

See Chapter 9, “Managing Replicated Tables” Chapter 10, “Managing Replicated Functions” and Chapter 11, “Managing Subscriptions.”

RSA, DBA

Defining data server function-string classes and function strings. See Chapter 2, “Customizing Database Operations,” in the Replication Server Administration Guide Volume 2.

RSA, DBA

Maintaining routes.

  • Creating and modifying routes.

See Chapter 6, “Managing Routes”

RSA

Maintaining and monitoring database connections.

  • Suspending and resuming connections.

See Chapter 7, “Managing Database Connections.”

RSA

Creating a warm standby application. See Chapter 3, “Managing Warm Standby Applications” in the Replication Server Administration Guide Volume 2.

RSA, DBA

Localizing Replication Server. Refer to the Replication Server Design Guide.

RSA

Adding a primary or replicate database. See Chapter 7, “Managing Database Connections.”

RSA, DBA

Adding or removing a Replication Server. See Chapter 4, “Managing a Replication System.”

RSA

Processing rejected transactions. See Chapter 6, “Handling Errors and Exceptions” in the Replication Server Administration Guide Volume 2.

RSA, DBA

Administering local data server.

  • Suspending or resuming data server.

See Adaptive Server or local server documentation.

DBA

Managing the RSSD. See Chapter 4, “Managing a Replication System.”

RSA, DBA

Managing Embedded Replication Server System Database (ERSSD). See Chapter 4, “Managing a Replication System.”

RSA, DBA

Creating, deleting, and modifying databases for replication. See Adaptive Server or local server documentation.

DBA

Setting up database user login names and passwords. See Adaptive Server or local server documentation.

DBA

Performing regular backups. See Chapter 1, “Verifying and Monitoring Replication Server” in the Replication Server Administration Guide Volume 2.

DBA

Applying database recovery procedures. See Chapter 7, “Replication System Recovery” in the Replication Server Administration Guide Volume 2.

RSA, DBA

Reconciling database inconsistencies. See Chapter 11, “Managing Subscriptions.”

RSA, DBA