About this book

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 Reference Manual, describes these Replication Server features:

• The Replication Command Language (RCL) used by Replication Server

• System functions for Replication Server

• Adaptive Server® commands and system procedures that you use with Replication Server

• Adaptive Server stored procedures that you use to manage the Replication Server system tables

• Replication Server executable programs, which you invoke directly from the operating system

• Replication Server system tables

The Replication Server Reference Manual is intended for anyone who uses Replication Server. It assumes that you have basic knowledge of how to use Replication Server.

This book is also for replication system Administrators who manage the routine operation of Replication Servers. Any user who has sa permission can be a replication system Administrator, although each Replication Server usually has just one.

The information in this book is organized as follows:

The Replication Server documentation set consists of the following:

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

Technical documentation at the Sybase Web site is updated frequently.

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

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

alter user user
set password new_passwd
[verify password old_passwd]

• Curly braces and vertical bars – choose only one option.

  {red | yellow | blue}
  

• Curly braces and commas – choose one or more options. If you choose more than one, separate your choices with commas.

  {cash, check, credit}
  

• One item in square brackets – choose it or omit it.

  [anchovies]
  

• Square brackets and vertical bars – choose none or only one.

  [beans | rice | sweet_potatoes]
  

• Square brackets and commas – choose none, one, or more options. If you choose more than one, separate your choices with commas.

  [extra_cheese, avocados, sour_cream]
  

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

alter function replication definition function_rep_def
{deliver as 'proc_name' |
 add @parameter datatype [, @parameter
datatype]... |
 add searchable parameters @parameter
  [, @parameter]... |
 send standby {all | replication definition}
   parameters}

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

• You can break a line anywhere except in the middle of a keyword or identifier. You can continue a character string on the next line by typing a backslash (\) at the end of the line.

• Extra space characters on a line are ignored, except after a backslash. Do not enter any spaces after a backslash.

• You can enter more than one command in a batch, unless otherwise noted.

• RCL commands are not transactional. Replication Server executes each command in a batch without regard for the completion status of other commands in the batch. Syntax errors in a command prevent Replication Server from parsing subsequent commands in a batch.

• Keywords in RCL commands are not case-sensitive. You can enter them with any combination of uppercase or lowercase letters.

• Identifiers and character data may be case-sensitive, depending on the sort order that is in effect.

  • If you are using a case-sensitive sort order, such as “binary,” you must enter identifiers and character data with the correct combination of uppercase and lowercase letters.

  • If you are using a sort order that is not case-sensitive, such as “nocase,” you can enter identifiers and character data with any combination of uppercase or lowercase letters.

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.

• Identifiers can be 1 – 255 bytes long (equivalent to 1 – 255 single-byte characters) and must begin with a letter, the @ sign, or the _ character. See “Identifiers,” in Chapter 2, “Topics” for a list of identifiers that have been extended to 255 bytes.

• Replication Server function parameters are the only identifiers that can begin with the @ character. Function parameter names can include 255 characters after the @ character.

• After the first character, identifiers can include letters, digits, and the #, $, or _ characters. Spaces are not allowed.

User-defined datatypes are not supported. The double precision, nchar, and nvarchar datatypes are indirectly supported by mapping them to other datatypes.

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

	Description
	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. 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. 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. 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 (RM), a management utility that lets a replication system administrator develop, manage, and monitor a Sybase Replication Server environment.

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.

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.