Discover millions of ebooks, audiobooks, and so much more with a free trial

From $11.99/month after trial. Cancel anytime.

IBM InfoSphere Replication Server and Data Event Publisher
IBM InfoSphere Replication Server and Data Event Publisher
IBM InfoSphere Replication Server and Data Event Publisher
Ebook722 pages4 hours

IBM InfoSphere Replication Server and Data Event Publisher

Rating: 0 out of 5 stars

()

Read preview

About this ebook

This is a developer's guide and is written in a style suitable to professionals. The initial chapters cover the basic theory and principles of Q replication and WebSphere MQ. As the book advances, numerous real-world scenarios and examples are covered with easy-to-understand code. The knowledge gained in these chapters culminate in the Appendix, which contains step-by-step instructions to set up various Q replication scenarios. If you are a professional who needs to set up and administer a Q replication or Event Publishing environment, then this is the book you need. The book will give you a clear idea of how to implement Q replication on z/OS whether you work on Linux, Unix, or Windows operating system.
LanguageEnglish
Release dateAug 18, 2010
ISBN9781849681551
IBM InfoSphere Replication Server and Data Event Publisher

Related to IBM InfoSphere Replication Server and Data Event Publisher

Related ebooks

Information Technology For You

View More

Related articles

Reviews for IBM InfoSphere Replication Server and Data Event Publisher

Rating: 0 out of 5 stars
0 ratings

0 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    IBM InfoSphere Replication Server and Data Event Publisher - Pav Kumar-Chatterjee

    it.

    Chapter 1. Q Replication Overview

    Welcome to the start of your journey along the Q replication road. Any journey can be a bumpy ride, but after reading this book and going through the numerous examples, your journey will be a smoother one! In this first chapter, we will take you through the following discussion points:

    Why we want to replicate data.

    What is available today in the IBM world of data replication.

    The toolsets available to set up and administer a replication environment and look at the code that we need to install for a functioning Q replication solution.

    Introduce the architecture of Q replication. We look at the different types of replication available, namely the base replication methods of unidirectional, bidirectional, and peer-to-peer, and the replication architectures built on these base methods.

    Replicating XML data types and compressed tables. We look at some of the design points when considering replicating compressed table.

    Q replication conflict detection.

    Available transformation processing for both regular and XML data.

    Why do we want to replicate data

    Much has been written about why we need to replicate data, so we will keep this short. What's wrong with just storing our data in one place? Well, in today's 24x7 world where being without data for even a short period of time could be catastrophic to our business, we need a method to be able to take a copy of our data and possibly more than one copy and store it securely in a different location. This copy should be complete and be stored as many miles away as possible. Also the amount of data that has to be stored is ever increasing and being generated at a fast rate, so our method needs to be able to handle large volumes of data very quickly.

    Overview of what is available today

    In the IBM software world today, there are a number of options available to replicate data:

    InfoSphere (formerly WebSphere) Replication Server

    InfoSphere CDC (formerly the Data Mirror suite of programs)

    The DB2 High Availability Disaster Recovery (HADR) functionality

    Traditional log shipping

    In this book, we will cover the first option InfoSphere Replication Server, which from now on, we will refer to as DB2 replication. The other options are outside the scope of this book.

    The different replication options

    In the world of DB2 replication, we have two main options—SQL replication and Q replication, both of which involve replicating between source and target tables. Event publishing is a subset of Q replication, in that the target is not a table but a WebSphere MQ queue. The choice of replication solution depends on a number of factors, of which the fundamental ones are:

    Type of source

    Type of target

    Operating system support

    The DB2 Information Center contains a table, which compares the three types of replication. This table can be used as a quick checklist for determining the best solution to a given business requirement (http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.swg.im.iis.db.repl.intro.doc/topics/iiyrcintrsbsc.html).

    The following figure shows the basic operations of SQL replication:

    Updates to any tables are logged, and if the table is a registered table (TAB1 and TAB2), then the SQL Capture program (Capture for short) reads the information from the DB2 log and inserts the row into a change data table (CD_)—there is one of these for each registered source table. The SQL Apply program (Apply for short) reads from these change data tables and updates the target tables (TAB3 and

    Enjoying the preview?
    Page 1 of 1