Book description
With ever-increasing workloads on production systems from transaction, batch, online query and reporting applications, the challenges of high availability and workload balancing are more important than ever.
This IBM® Redbooks® publication provides descriptions and scenarios for high availability solutions using the Q Replication technology of the IBM InfoSphere® Data Replication product on the IBM z/OS® platform. Also included are key considerations for designing, implementing, and managing solutions for the typical business scenarios that rely on Q Replication for their high availability solution.
This publication also includes sections on latency analysis, managing Q Replication in the IBM DB2® for z/OS environment, and recovery procedures. These are topics of particular interest to clients who implement the Q Replication solution on the z/OS platform.
Q Replication is a high-volume, low-latency replication solution that uses IBM WebSphere® MQ message queues to replicate transactions between source and target databases or subsystems. A major business benefit of the low latency and high throughput solution is timely availability of the data where the data is needed.
High availability solutions are implemented to minimize the impact of planned and unplanned disruptions of service to the applications. Disruption of service can be caused by software maintenance and upgrades or by software and hardware outages. As applications' high availability requirements evolve towards continuous availability, that is availability of the data 24 hours a day and 7 days a week, so does the Q Replication solution, to meet these challenges.
If you are interested in the Q Replication solution and how it can be used to implement some of the high availability requirements of your business scenarios, this book is for you.
Table of contents
- Front cover
- Notices
- Preface
- Chapter 1. High Availability scenarios
- Chapter 2. IIDR Q Replication overview
-
Chapter 3. The two-node scenario
- 3.1 Introduction to Q Replication
- 3.2 Scenario architecture and topology
- 3.3 Replicating simple tables
- 3.4 Using non-persistent queues
- 3.5 Replicating temporal tables
-
3.6 Using parallel send queues
- 3.6.1 Configuring WebSphere MQ for parallel send queues
- 3.6.2 Starting WebSphere MQ communications
- 3.6.3 Creating Q Map for parallel send queues
- 3.6.4 Reviewing SENDQ and RECVQ parallel send queue columns
- 3.6.5 Creating Q Subscriptions for parallel send queues
- 3.6.6 Activating new Q Maps/Q Subscriptions replication
- 3.6.7 Replicating data
- 3.6.8 Checking the status of Q Replication
- Chapter 4. The advanced two-node scenario
-
Chapter 5. The three-node scenarios
- 5.1 Introduction to three-site replication
-
5.2 The three-node partially connected scenario
- 5.2.1 Scenario architecture and topology
- 5.2.2 Q Replication V10.2.1 and DB2 for z/OS V10 NFM
- 5.2.3 Conflict avoidance strategy using DB2 for z/OS
- 5.2.4 Recapturing of transactions at the primary node
- 5.2.5 Filtering transactions by using the IBMQREP_IGNTRAN table
- 5.2.6 Managing exceptions and the IBMQREP_EXCEPTIONS table
- 5.2.7 Q Apply program exploiting DB2 for z/OS MRI function
- 5.3 The three-node fully connected scenario
-
Chapter 6. Latency analysis
- 6.1 Overview
-
6.2 Q Capture latency
- 6.2.1 The Q Capture latency
- 6.2.2 Determine if Q Capture is keeping up with the DB2 log activity
- 6.2.3 DB2 IFI time
- 6.2.4 Determine why (what) Q Capture is waiting (on)
- 6.2.5 WebSphere MQ PUT time and MQ COMMIT Time
- 6.2.6 Determine if Q Capture spilled a transaction
- 6.2.7 Determine if the transmit queue is becoming a bottleneck
- 6.2.8 Tuning the Q Capture program
- 6.3 Q Apply latency
- 6.4 Queue latency
- 6.5 Batch workloads
- 6.6 The Data Replication Dashboard
- Chapter 7. Managing Q Replication in the DB2 for z/OS Environment
- Chapter 8. Recovery procedures
- Appendix A. Using ASNCLP on z/OS
- Appendix B. Additional material
- Related publications
- Back cover
Product information
- Title: Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform
- Author(s):
- Release date: January 2014
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
Implementing High Availability and Disaster Recovery in IBM PureApplication Systems V2
This IBM Redbooks publication describes and demonstrates common, prescriptive scenarios for setting up disaster recovery for …
book
WebSphere Replication Server for z/OS Using Q Replication: High Availability Scenarios for the z/OS Platform
This IBM Redbooks publication provides detailed instructions and scripts for managing failover and switchback in a …
book
Security Functions of IBM DB2 10 for z/OS
IBM® DB2® 9 and 10 for z/OS® have added functions in the areas of security, regulatory …
book
WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
This IBM Redbooks publication provides an overview of WebSphere Information Integrator Q replication, and provides guidelines …