Replication Guide and Reference

About this book

This book introduces the concepts of DB2 data replication, and it describes how to plan, configure, and administer a replication environment.

The DB2 DataPropagator product is the focus of the book. You can use it with other products in the IBM replication solution to tailor a replication environment that suits your business needs.

You can replicate data from DB2 sources to DB2 targets. You can also replicate data between DB2 and non-IBM sources and targets. Specifically, you can use the following database management systems as sources, targets, or both:

DB2 servers	Non-IBM servers
DB2 Universal Database for AIX	Informix(R)2
DB2 Universal Database for AS/400	Microsoft Access3
DB2 Universal Database for HP-UX(R)	Microsoft Jet3
DB2 Universal Database for OS/2	Microsoft SQL Server2
DB2 Universal Database Server for OS/390	Oracle(R)2
DB2 Universal Database for Solaris(TM)	Sybase(R)2
DB2 Universal Database for Linux(R)	Sybase SQL Anywhere(TM)2
DB2 Universal Database for NUMA-Q(R)	Teradata(R)4
DB2 Universal Database for VM1
DB2 Universal Database for VSE1
DB2 Universal Database for Windows 32-bit operating systems (such as Windows 95, 98 and NT(R))

Who should read this book

This book is written for database administrators, LAN administrators, and others who must set up and maintain a data replication environment. It assumes that you are familiar with standard database terminology, that you have experience with database design and database administration, and that you understand your applications and the data that you want to replicate.

How this book is structured

This book consists of the following parts:

Part 1: Introduction

Introduces the DB2 replication concepts and components, describes the typical replication configurations, guides you through a simple replication scenario using the DB2 Control Center, and outlines the major replication tasks that are described in the book.

Part 2: Administration

Describes how to plan, set up, run, and maintain your replication environment.

Part 3: Operations

Describes how to use DB2 data replication in particular operating systems.

Part 4: Reference information

Provides reference information for control table structures (which are relational database tables that DB2 DataPropagator uses during its replication process), and messages.

Conventions

This book uses these highlighting conventions:

• Boldface type indicates commands or user interface controls such as names of fields, folders, icons, or menu choices.
• Monospace type indicates examples of text that you enter exactly as shown.
• Italic type indicates variables that you should replace with a value. It is also used to indicate book titles and for emphasis of words.

Terminology

This book uses standard terminology for database, copying, and LAN concepts. Overview of data replication explains many concepts used in this book. For definitions of replication terms, see Glossary.

How to read syntax diagrams

The following rules apply to the syntax diagrams used in this book:

• Read the syntax diagrams from left to right, from top to bottom, following the path of the line.

  The >>--- symbol indicates the beginning of a statement.

  The ---> symbol indicates that the statement syntax is continued on the next line.

  The >--- symbol indicates that a statement is continued from the previous line.

  The --->< symbol indicates the end of a statement.

  Diagrams of syntactical units other than complete statements start with the >--- symbol and end with the ---> symbol.

• Keywords, their allowable synonyms, and reserved parameters, are either shown in uppercase or lowercase, depending on the operating system. These items must be entered exactly as shown. Variables appear in lowercase italics (for example, column-name). They represent user-defined parameters or suboptions.

  When entering commands, separate the parameters and keywords by at least one space if there is no intervening punctuation.

• Enter punctuation marks (slashes, commas, periods, parentheses, quotation marks, equal signs, and so on) and numbers exactly as given.
• Footnotes are shown by a number in parentheses, for example, (1).
• Required items appear on the horizontal line (the main path).

  >>-required_item-----------------------------------------------><
   
  

• Optional items appear below the main path.

  >>-required_item--+---------------+----------------------------><
                    '-optional_item-'
   
  

• If you can choose from two or more items, they appear vertically, in a stack.

  If you must choose one of the items, one item of the stack appears on the main path.

  >>-required_item--+-required_choice1-+-------------------------><
                    '-required_choice2-'
   
  

  If choosing one of the items is optional, the entire stack appears below the main path.

  >>-required_item--+------------------+-------------------------><
                    +-optional_choice1-+
                    '-optional_choice2-'
   
  

Road map

How to send your comments

Your feedback helps IBM to provide quality information. Please send any comments that you have about this book or other DB2 DataPropagator documentation. You can use any of the following methods to provide comments:

• Send your comments from the Web. Visit the Web site at:

  http://www.ibm.com/software/data/dpropr/

  The Web site has a feedback page that you can use to enter and send comments.

• Send your comments by e-mail to comments@vnet.ibm.com. Be sure to include the name of the product, the version number of the product, and the name and part number of the book (if applicable). If you are commenting on specific text, please include the location of the text (for example, a chapter and section title, a table number, a page number, or a help topic title).

¹

There is no Apply program for these products.

²

These products require DB2 DataJoiner V2 or later and the DB2 DataJoiner Replication Administration (DJRA) tool.

³

These products require DJRA.

⁴

There is no Capture program for this product.