Sybase Replication Server 

An Administrator's Guide

What's in the Book?

Introduction                                                            

Data Distribution                                                    

Distribution V Replication                                    

Replication Methods

Asynchronous replication                                     

Asynchronous Replication

File Transfer Replication

Snapshot

Log based

Transactional replication

Sybase Replication

Introduction

Replication Server Processing

Log Transfer Manager

Replication (or Secondary) Truncation Point

LTM Processing

Stable Queue Manager

Queue Space Management

SQM Duplicate Detection

Stable Queue Transaction Manager

SQT Cache Size

Replication Server Memory

Distributor Thread

Subscription Resolution Engine

Transaction Delivery

Message Delivery

Data Service Interface

Replication Service Interface

RSI Receiver Thread

RSI Sender Thread

Introduction

Defining Routes

Direct Route

Indirect Route

Configuring a Direct Route

Suspending and Resuming a Route

Dropping a Route

Altering a Route

Viewing Route Information

System Tables

Troubleshooting

Introduction

Creating Connections with rs_init

Primary Database

Replicate Database

Creating Connections with the Create Connection Command

Create the Connection

Configuring the Connection

Suspending a Connection

Resuming a Connection

Exception Log

Dropping a Connection

Altering a Connection

Displaying Connection Information

Parallel DSI Threads

Parallel DSI Configuration

Transaction Serialization

Details of Update Conflict

Processing Large and Small Transactions

Introduction

Creating a Replication Definition

Datatype Considerations

Minimal Replication Definition

Restricting the Columns

Different Replication Table Name

Minimal Columns

Recording the Replication Definition

Marking the Table for Replication

Text/image Replication

Viewing Replication Definition Information

Altering a Replication Definition

Dropping a Replication Definition

System Tables

Basic Troubleshooting

Introduction

Types of Materialisation

Manual Materialisation

Automatic Materialisation

Defining a Subscription for Manual Materialisation

Define Subscription

Activate Subscription

Recording the Subscription Activation

Validate Subscription

Check Subscription

Defining a Subscription with Automatic Materialisation

Atomic Materialisation

Incremental Atomic Materialisation

Non-atomic Materialisation

Bitmap Subscription

Dropping a Subscription

Help on Subscriptions

System Tables

Basic Troubleshooting

Introduction

Publications

Creating the Publication

Checking the Publication

Dropping the Publication

Validate the Publication

Viewing Publication Information

Articles

Creating the Article

Dropping the Article

Viewing Article Information

Subscriptions to Publications

Viewing Subscription Information for a Publication

Introduction

Functions and Function Instances

Function Scope

Function String Class Scope

Transaction Control

Replication Coordination

Function Strings and Function String Classes

Function String Class

Creating Function String Classes

Displaying Function Class Information

Changing the Primary Site of a Function String Class

Altering a Function String Class

Dropping a Function String Class

Function String

Creating a Function String

Altering a Function String

Language Templates

Rpc Templates

Restoring Default Function String

Dropping Function Strings

Function String Help

System Tables

Introduction

Function Replication

Create the Function Replication Definition

Applied Function Replication

Create the Procedure

Grant Execute on the Procedure to the Maintenance User

Create the Function Replication Definition

Define and Materialize the Subscription

Mark the Function Replication Definition for Replication

Request Function Replication

Altering a Function Replication Definition

Dropping a Function Replication Definition

User Defined Functions

Create a User Defined Function

Dropping a User Defined Function

Viewing Function Replication Definition Information

System Tables

Introduction

Architecture

Warm Standby Setup

Create the Logical Connection

Creating the Database Connection

rs_init

Create Connection

Enabling Objects in the Active Database

Initializing the Standby Database

Reinitializing a Standby Database

Maintenance User Permissions

Resuming the Standby Database Connection

Defining Replication Definitions and Subscriptions

Replication Definition

Subscriptions

Introduction

Error Classes

Creating an Error Class

Defining the Primary Site

Initializing an Error Class

Dropping an Error Class

Associating an Error Class with a Database

Displaying error Class Information

Assigning Error Actions

Displaying Error Action Information

Exceptions Tables

Introduction

Replication Server Parameters

Connection Parameters

Route Parameters

LTM Parameters

Introduction

System Planning

Replication Servers

Log Transfer Managers

Replication Server Users

Managing Replication Server Users

Disk Space Requirements

The Installation Directory

Errorlog File

The Stable Device

The Replication Server System Database

Installing the Software

Using rs_init with Resource Files

Creating DSI Threads

Command Line Creation

Database Already has a DSI Connection

Load of Dump from Non-replicated Database

Creating DSI Using rs_init

Resource File for Setting Up DSI Threads

Introduction

Replication Server Thread Processes

LTM Processes

Replication Server Log Files

Primary SQL Server Processes

Replicate SQL Server Processes

Restarting a Failed Thread

Disk Space

Stable Device

Individual Queue Sizes

Latency

Replication Latency

Queue Latency

Memory

Replication Server Memory

LTM Memory

CPU Usage

Disk Activity

Network Activity

Introduction

What Commonly Goes Wrong?

Duplicate Row in Replicate Database

Replicate Database or Log Full

Maintenance User Cannot Access Replicate Database

Troubleshooting Commands

Replication Server Queue and Thread States

Stable Device Usage

Analyzing Problems

DSI Suspended

Apparent Failure to Replicate

LTM to Repserver Inbound Queue

Inbound Queue to Outbound Queue

Orphaned Transaction

Dropping DSI when Replication Database has been Dropped

Emergency RSI Removal

Stable Device Full

Introduction

General Principles

Replicate Database Recovery

Primary Database Recovery

Primary/replicate Database Recovery

Recovery from Offline Transaction Log Dumps

Recovering from Partition Loss

Recovering from a Failed RSSD

Basic RSSD Recovery

Introduction

Enabling and Disabling RepAgent

Enable RepAgent

Disable RepAgent

Configuring RepAgent

Starting and Stopping RepAgent

Starting RepAgent

Stopping RepAgent

Help on RepAgent

Appendix A: System Tables

Appendix B: Command Syntax

Appendix C: RSSD System Procedures

Appendix D: ASE Commands and System Procedures

Appendix E: Replication Server Programs

Back to Index