IBM InfoSphere Replication Server and Data Event Publisher
()
About this ebook
Related to IBM InfoSphere Replication Server and Data Event Publisher
Related ebooks
Microsoft SQL Server 2008 R2 Administration Cookbook Rating: 5 out of 5 stars5/5Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) Rating: 0 out of 5 stars0 ratingsOracle 11g Streams Implementer's Guide Rating: 0 out of 5 stars0 ratingsDB2 Exam C2090-313 Preparation Guide Rating: 0 out of 5 stars0 ratingsIBM DB2 9.7 Advanced Application Developer Cookbook Rating: 0 out of 5 stars0 ratingsBeginning Microsoft SQL Server 2012 Programming Rating: 1 out of 5 stars1/5BMC Control-M 7: A Journey from Traditional Batch Scheduling to Workload Automation Rating: 0 out of 5 stars0 ratingsDB2 10 for z/OS: The Smarter, Faster Way to Upgrade Rating: 0 out of 5 stars0 ratingsDB2 9 System Administration for z/OS: Certification Study Guide: Exam 737 Rating: 3 out of 5 stars3/5DB2 Exam C2090-320 Preparation Guide Rating: 0 out of 5 stars0 ratingsDB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes Rating: 5 out of 5 stars5/5DB2 9 for Developers Rating: 0 out of 5 stars0 ratingsAmazon Redshift A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsMainframe Modernization A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsIBM Integration Bus Third Edition Rating: 0 out of 5 stars0 ratingsAmazon Redshift A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsOracle Database 11g R2 Performance Tuning Cookbook Rating: 0 out of 5 stars0 ratingsGetting Started with Big Data Query using Apache Impala Rating: 0 out of 5 stars0 ratingsDB2 11.1 for LUW: Basic Training for Application Developers Rating: 0 out of 5 stars0 ratingsLearn Hbase in 24 Hours Rating: 0 out of 5 stars0 ratingsWildFly Cookbook Rating: 0 out of 5 stars0 ratingsIBM MQ A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsIBM DB2 9.7 Advanced Administration Cookbook Rating: 0 out of 5 stars0 ratingsDB2 Exam C2090-320 Practice Questions Rating: 0 out of 5 stars0 ratingsAn Introduction to IBM Rational Application Developer: A Guided Tour Rating: 5 out of 5 stars5/5PostgreSQL 9 High Availability Cookbook Rating: 5 out of 5 stars5/5Monitoring Hadoop Rating: 0 out of 5 stars0 ratingsDB2 Interview Questions, Answers, and Explanations: DB2 Database Certification Review Rating: 0 out of 5 stars0 ratingsETL A Clear and Concise Reference Rating: 0 out of 5 stars0 ratingsDell Boomi A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratings
Information Technology For You
An Ultimate Guide to Kali Linux for Beginners Rating: 3 out of 5 stars3/5CompTIA ITF+ CertMike: Prepare. Practice. Pass the Test! Get Certified!: Exam FC0-U61 Rating: 5 out of 5 stars5/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Health Informatics: Practical Guide Rating: 0 out of 5 stars0 ratingsSummary of Super-Intelligence From Nick Bostrom Rating: 4 out of 5 stars4/5CompTia Security 701: Fundamentals of Security Rating: 0 out of 5 stars0 ratingsCODING INTERVIEW: Advanced Methods to Learn and Excel in Coding Interview Rating: 0 out of 5 stars0 ratingsCybersecurity for Beginners : Learn the Fundamentals of Cybersecurity in an Easy, Step-by-Step Guide: 1 Rating: 0 out of 5 stars0 ratingsSupercommunicator: Explaining the Complicated So Anyone Can Understand Rating: 3 out of 5 stars3/5CompTIA A+ CertMike: Prepare. Practice. Pass the Test! Get Certified!: Core 1 Exam 220-1101 Rating: 0 out of 5 stars0 ratingsData Analytics for Beginners: Introduction to Data Analytics Rating: 4 out of 5 stars4/5The Programmer's Brain: What every programmer needs to know about cognition Rating: 5 out of 5 stars5/5Learning Microsoft Endpoint Manager: Unified Endpoint Management with Intune and the Enterprise Mobility + Security Suite Rating: 0 out of 5 stars0 ratingsCOMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsRaspberry Pi :Raspberry Pi Guide On Python & Projects Programming In Easy Steps Rating: 3 out of 5 stars3/5Understanding TCP/IP Rating: 4 out of 5 stars4/5Self-Sovereign Identity Rating: 0 out of 5 stars0 ratingsCompTIA Security+: Network Attacks Rating: 5 out of 5 stars5/5How to Find a Wolf in Siberia (or, How to Troubleshoot Almost Anything) Rating: 0 out of 5 stars0 ratingsCyber Security Consultants Playbook Rating: 0 out of 5 stars0 ratingsCompTIA Network+ CertMike: Prepare. Practice. Pass the Test! Get Certified!: Exam N10-008 Rating: 0 out of 5 stars0 ratingsGetting an IT Help Desk Job For Dummies Rating: 0 out of 5 stars0 ratingsInkscape Beginner’s Guide Rating: 5 out of 5 stars5/5Random Tech Rating: 0 out of 5 stars0 ratingsA Mind at Play: How Claude Shannon Invented the Information Age Rating: 4 out of 5 stars4/5The iPadOS 17: The Complete User Manual to Quick Set Up and Mastering the iPadOS 17 with New Features, Pictures, Tips, and Tricks Rating: 0 out of 5 stars0 ratingsThe Design Inference Rating: 5 out of 5 stars5/5The Rise of AI Income: Using Artificial Intelligence for Financial Success Rating: 5 out of 5 stars5/5
Reviews for IBM InfoSphere Replication Server and Data Event Publisher
0 ratings0 reviews
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_