About this book

Audience

This book is intended for those who are responsible for:

How to use this book

This book contains these chapters:

Chapter 1, “15.0 Replication Agent Overview,” explains the basic concepts of replication systems, the role of Replication Agent, the role that connectivity plays in replication systems, and how replication works in a data-sharing environment.

Chapter 2, “Replication Server Setup,” explains how to prepare a system for replication and what you need to know about datatype conversions before you begin.

Chapter 3, “Replication Agent Setup,” provides information about DB2 considerations that affect working with source tables. It also explains how to mark tables for replication.

Chapter 4, “Managing Replication Agent,” explains how to start up and shut down Replication Agent. It discusses Replication Agent startup problems, how to monitor LTM for MVS and Replication Server, and provides replication failure troubleshooting tips.

Chapter 5, “Known Issues and Error Recovery,” explains the known restrictions on Replication Agent and provides error recovery procedures.

Appendix A, “LTM for MVS Configuration Parameters,” discusses the LTM for MVS configuration file and the parameters that control the LTM for MVS component of Replication Agent.

Appendix B, “Replication Extract Messages,” lists and describes the messages issued by Replication Extract.

Appendix C, “LTM for MVS Messages,” lists the LTM for MVS error and infomational messages and suggests fixes for the errors they represent.

Appendix D, “MVS Console Messages,” lists Replication Agent error and informational messages and suggest fixes for the errors they represent.

Appendix E, “Running Multiple Replication Agents,” explains how to run multiple Replication Agents in a replication system.

Appendix F, “Creating User Exits,” provides information about the transaction programs written to take control at a determined point in a program (user exit).Replication Agent for DB2 UDB

Related documents

Other sources of information

Use the Sybase Getting Started CD, the SyBooks 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 Certification Report.

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

  4. Click a 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.

Style conventions

Table 1 shows some of the style conventions used in the documentation for this product.

Table 1: Style conventions

Text

Explanation

Example

Bold

  • Programs

  • Utilities

  • Procedures

  • Commands

create connection

Italics

  • File names

  • Directory names

  • Properties

confiuration file

Code
  • Code examples

  • Screen text

Replication Agent for DB2/12.6

Bold code

  • User input

  • Command line input

/F [job_name],C, trace=LTLebcdic

Italics

Variables (replace these with the appropriate values for your site)

host_name

Code italics

Variables in code you type (replace these with the appropriate values for your site)

maintenance_user_ID

Syntax conventions

The following example illustrates some of the syntax conventions used in this guide:

COMMAND [object_name, [ {TRUE | FALSE} ] ]

Table 2 explains the syntax conventions used in this guide.

Table 2: Syntax conventions

Symbol

Explanation

Example

( )

Include parentheses as part of the command.

START DATABASE (database_name)

|

A vertical bar indicates that you can select only one of the options shown. Do not type the bar in your command.

{red|yellow|blue}

,

A comma indicates that you can choose one or more of the options shown. Separate each choice by using a comma as part of the command.

{rice,potatoes,beans}

{ }

Braces indicate that you must choose at least one of the enclosed options. Do not type the braces when you enter the option.

Select only one:

{red|yellow|blue}

Select at least one:

{rice,potatoes,beans}

[ ]

Brackets indicate that you can choose one or more of the enclosed options, or none. Do not type the brackets when you enter the options.

[anchovies]

...

An ellipsis indicates that you can repeat the previous item as many times as necessary.

{rice,potatoes}...

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.