About this book

Sybase® Replication Server® maintains replicated data at multiple sites on a network. Organizations with geographically distant sites can use Replication Server to create distributed database applications with better performance and data availability than a centralized database system can provide.

This book, Replication Server Administration Guide, provides an overview of how Replication Server works, and describes Replication Server administrative tasks.

Audience

The Replication Server Administration Guide is for replication system administrators, who manage the routine operation of their Replication Servers. Any user who has been granted the sa permission can be a replication system administrator, although each Replication Server usually has just one.

How to use this book

This book contains the following chapters:

Volume 2 of the System Administration Guide contains these chapters:

Related documents

The Sybase Replication Server documentation set consists of:

Other sources of information

Use the Sybase Getting Started CD and the Sybase Product Manuals Web site to learn more about your product:

Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

StepsFinding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Click Partner Certification Report.

  3. In the Partner Certification Report filter select a product, platform, and timeframe and then click Go.

  4. Click a Partner Certification Report title to display the report.

StepsFinding the latest information on component certifications

  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

StepsCreating a personalized view of the Sybase Web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.

Sybase EBFs and software maintenance

StepsFinding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.

Conventions

This section describes the style and syntax conventions, RCL command formatting conventions, and icons used in this book.

Style conventions Syntax statements that display the syntax and options for a command are printed as follows:

alter user user
set password new_passwd
[verify password old_passwd]

See “Syntax conventions” for more information.

Examples that show the use of Replication Server commands are printed as follows:

alter user louise
 set password somNIfic
 verify password EnnuI

Command names, command option names, program names, program flags, keywords, functions, and stored procedures are printed as follows:

Use alter user to change the password for a login name.

Variables, parameters, and user-supplied words are in italics in syntax and in paragraph text, as follows:

The set password new_passwd clause specifies a new password.

Names of database objects such as databases, tables, columns, and datatypes, are in italics in paragraph text, as follows:

The base_price column in the Items table is a money datatype.

Names of replication objects, such as function-string classes, error classes, replication definitions, and subscriptions, are in italics.

Syntax conventions Syntax formatting conventions are summarized in the following table. Examples combining these elements follow.

Table 1: Syntax formatting conventions

Key

Definition

{ }

Curly braces mean you must choose at least one of the enclosed options. Do not include braces in the command.

[ ]

Brackets mean you may choose or omit enclosed options. Do not include brackets in the command.

|

Vertical bars mean you may choose no more than one option (enclosed in braces or brackets).

,

Commas mean you may choose as many options as you need (enclosed in braces or brackets). Separate your choices with commas, to be typed as part of the command.

Commas may also be required in other syntax contexts.

( )

Parentheses are to be typed as part of the command.

...

An ellipsis (three dots) means you may repeat the last unit as many times as you need. Do not include ellipses in the command.

Obligatory choices

Optional choices

Repeating elements

An ellipsis (...) means that you may repeat the last unit as many times as necessary. For the alter replication definition command, for example, you can list one or more columns and their datatypes for the add clause or the add searchable columns clause:

alter replication definition replication_definition
{add column datatype [, column datatype]... |
 add searchable columns column [, column]... |
 replicate {minimal | all} columns}

RCL command formatting

RCL commands are similar to Transact-SQL® commands. The following sections present the formatting rules.

Command format and command batches

Case sensitivity

Identifiers

Identifiers are names you give to servers, databases, variables, parameters, database objects, and replication objects. Database object names include names for tables, columns, and views. Replication object names include names for replication definitions, subscriptions, functions, and publications.

Parameters in function strings

Parameters in function strings have the same rules as identifiers, except that:

Data support Replication Server supports all Adaptive Server datatypes.

User-defined datatypes are not supported. The double precision, nchar, and nvarchar datatypes are indirectly supported; they are mapped to other datatypes.

For more information about the supported datatypes, including how to format them, see “Datatypes,” in Chapter 2, “Topics” of the Replication Server Reference Manual.

Terminology

In this book, Replication Agent is the generic term used for describing the Replication Agent for Adaptive Server® Enterprise, Oracle, IBM DB2 UDB, and Microsoft SQL Server. The specific names are:

Icons

Illustrations in this book use icons to represent the components of a replication system.

Description

This icon represents Replication Server, the Sybase server program that maintans replicated data on a local-area network (L A N) and processes data transactions received from other Replication Servers on wide-area network (W A N).

This icon represents Replication Server, the Sybase server program maintains replicated data on a local-area network (LAN) and processes data transactions received from other Replication Servers on wide-area network (WAN).

This icon represents Adaptive Server, the Sybase data server. Data servers manage databases containing primary or replicated data.

This icon represents Adaptive Server, the Sybase data server. Data servers manage databases containing primary or replicated data. Replication Server also works with heterogeneous data servers, so, unless otherwise noted, this icon can represent any data server in a replication system.

This icon represents Replication Agent, a replication system process or module that transfers transaction log information for primary database to a Replication Server. The Replication Agent for Adaptive Server is RepAgent.

This icon represents Replication Agent™, a replication system process or module that transfers transaction log information for primary database to a Replication Server. The Replication Agent for Adaptive Server is RepAgent. Sybase provides Replication Agent products for Adaptive Server® Anywhere, DB2, Microsoft SQL Server, and Oracle data servers.

Except for RepAgent, which is an Adaptive Server thread, all Replication Agents are separate processes. In general, this icon only appears when representing a Replication Agent that is a separate process.

This icon represents client application. A client application is a user process or application connected to a data server.

This icon represents client application. A client application is a user process or application connected to a data server. It may be a front-end application program executed by a user or a program that executes as an extension of the system.

This icon represents the Sybase Central Replication Manager plug-in, a management utility that lets a replication system administrator develop, manage, and monitor a Sybase Replication Server environment.

This icon represents the Sybase Central Replication Manager plug-in (RM), a management utility that lets a replication system administrator develop, manage, and monitor a Sybase Replication Server environment.

Accessibility features

This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.

Replication Server HTML documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.

NoteYou might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool.

For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

If you need help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.