SQL Replication information roadmap

This roadmap shows the information resources that are available for SQL Replication.

Overview

IBM® Data Replication Community Wiki: Resources for IBM Data Replication users of Q Replication, SQL Replication, and CDC Replication.
Introduction to replication and event publishing: Describes the basics of Q Replication, SQL Replication, and Event Publishing along with business cases to illustrate the uses of each.
A Practical Guide to Db2 UDB Data Replication V8: Provides detailed information on installing, configuring, and implementing replication among the IBM database family — Db2 and Informix.
Basic SQL Replication tutorial: Db2 for Windows: Helps you gain experience in using the Replication Center and the Capture, Apply, and Replication Alert Monitor programs.
System requirements for IBM InfoSphere Data Replication for Db2 for z/OS Version 11.4: System requirements for the mainframe Q Replication, SQL Replication, and CDC Replication technologies in Version 11.4.
System requirements for IBM InfoSphere Data Replication 11.4: System requirements for the distributed Q Replication, SQL Replication, and CDC Replication technologies in Version 11.4.
Extend your Information Governance Catalog with SQL Replication Metadata: Explains how to integrate your SQL Replication subscriptions into the InfoSphere Governance Catalog for data lineage.

Installing and customizing for z/OS: Companion to the Program Directory for IBM InfoSphere Data Replication for Db2 for z/OS that helps you install and configure a replication environment.
Program Directory for InfoSphere® Data Replication for Db2® for z/OS® 11.04.00: This program directory (GI13-2893-00) describes how to install InfoSphere Data Replication for DB2® for z/OS 11.4.
Program Directory for InfoSphere Data Replication for Db2 for z/OS 10.02.02: This program directory (GI10-8941-04) describes how to install InfoSphere Data Replication for DB2 for z/OS 10.2.2.
Program Directory for InfoSphere Data Replication for Db2 for z/OS 10.02.01: This program directory (GI10-8941-02) describes how to install InfoSphere Data Replication for DB2 for z/OS 10.2.1.

Migrating to Version 11.4 (z/OS): SQL Replication in Version 11.4 on z/OS does not require a migration from Version 10.2.1 with ARCH_LEVEL 1021.
Migrating to Version 11.1 (Linux, UNIX, Windows): Steps for migrating the SQL Replication control tables to architecture level 1021 after you upgrade to Db2 Version 11.1 on Linux, UNIX, and Windows.

Planning: How to plan for migration, memory, storage, conflict detection, and other details of a SQL Replication environment.
Configuring servers: Describes connectivity, authorization, setting up control tables, setting up the replication programs, and setting up journals.
Registering tables and views as sources: Describes how to identify tables and views as replication sources, specify which columns you want to replicate, and set the properties for capturing data and changes from the source.
Subscribing to sources: How to plan and define a subscription for your target tables or views so that they receive the source data and the changes from those sources.
Password file management: Explains how to store user IDs and passwords in an encrypted password file.

Operating the Capture program: How to start, stop, and change parameters for the program that controls log-based capture from registered source tables.
Operating the Apply program: How to start and stop the Apply program and use the ASNDONE and ASNLOAD exit routines.
Changing a SQL Replication environment: Adding, changing, or removing replication objects such as registrations, subscription sets, and subscription set members.
Replication Center tasks that are no longer available: A listing of the operational functions in the Replication Center that are no longer available, with suggested replacements.

Replication Alert Monitor: How to create and operate the monitor program, which sends alerts to email, pager, or the z/OS console. Includes information about system commands and control tables.
Performance tuning: How to tune Db2 and the replication programs for optimal SQL Replication performance.

Collecting troubleshooting data: How to gather information to help in diagnosing a problem.
Detecting and repairing differences between source and target tables: Describes the asntdiff and asntrepair utilities, which automatically find and resolve differences between source and target tables.

SQL Replication Guide and Reference: PDF version of the SQL Replication user guide.
System commands: Commands for Linux, UNIX, Windows, and z/OS operating systems to start, operate, and modify the replication programs.
ASNCLP commands for replication and event publishing: Usage and syntax information for the command-line interface for Q Replication and Event Publishing.
Table structures: Descriptions of the columns and data definitions for the Capture and Apply control tables and tables at the target server.
Replication error messages: Documentation for messages that are issued by the replication programs, listed in numeric sequence.