WebSphere information integrator Q replication : fast track implementation scenarios / [Nagraj Alur ... et al.].

Format:

Book

Author/Creator:

Alur, Nagraj.

Contributor:

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

WebSphere.

Physical Description:

1 online resource (946 p.)

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, 2005.

Language Note:

English

System Details:

text file

Summary:

This IBM Redbooks publication provides an overview of WebSphere Information Integrator Q replication, and provides guidelines for exploiting its high throughput, low latency, and other capabilities in the design and implementation of high-availability and high-performance distributed business solutions on the z/OS and AIX platforms. It also describes a step-by-step approach to implementing bidirectional and peer-to-peer replication solutions in a two-server environment on the z/OS and AIX platforms.

Contents:

Front cover

Contents

Figures

Tables

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Chapter 1. Introduction to replication technologies

1.1 Business of replication

1.2 Replication options

1.3 Asynchronous replication options

1.4 IBM product offerings

1.5 SQL replication, Q replication, and HADR comparison

Chapter 2. WebSphere Information Integrator Q replication overview

2.1 Q replication overview

2.1.1 Unidirectional replication

2.1.2 Bidirectional replication

2.1.3 Peer-to-peer replication

2.1.4 Replication Alert Monitor

2.2 Q replication processing flow

2.2.1 Initial synchronization of the data at the source and target

2.2.2 Ongoing replication after the initial synchronization

2.3 Choosing a particular Q replication topology

2.4 Best practices considerations

2.4.1 Q Capture considerations

2.4.2 Replication queue map considerations

2.4.3 Q Apply considerations

2.4.4 WebSphere MQ considerations

2.4.5 Latency considerations

Chapter 3. Bidirectional Q replication on z/OS platforms

3.1 Introduction

3.2 Business requirement

3.3 Rationale for the bidirectional solution

3.4 Environment configuration

3.5 Step-by-step setup

3.5.1 Step 1: Install WebSphere MQ, WebSphere II with Q replication

3.5.2 Step 2: Determine topology

3.5.3 Step 3: Collect topology and configuration information

3.5.4 Step 4: Set up user IDs, privileges, and database servers

3.5.5 Step 5: Configure WebSphere MQ

3.5.6 Step 6: Configure and activate Q replication using GUI

3.5.7 Step 6: Configure and activate Q replication using commands

3.5.8 Step 7: Set up monitoring environment using GUI

3.5.9 Step 7: Set up monitoring environment using commands

3.6 Failover considerations.

3.7 Switchback considerations

Chapter 4. Peer-to-peer Q replication on z/OS platforms

4.1 Introduction

4.2 Business requirement

4.3 Rationale for the peer-to-peer solution

4.4 Environment configuration

4.5 Step-by-step setup

4.5.1 Step 1: Install WebSphere MQ, WebSphere II with Q replication

4.5.2 Step 2: Determine topology

4.5.3 Step 3: Collect topology and configuration information

4.5.4 Step 4: Set up user IDs, privileges, and database servers

4.5.5 Step 5: Configure WebSphere MQ

4.5.6 Step 6: Configure and activate Q replication using GUI

4.5.7 Step 6: Configure and activate Q replication using commands

4.5.8 Step 7: Set up monitoring environment using the GUI

4.6 Failover considerations

4.7 Switchback considerations

Chapter 5. Bidirectional Q replication on AIX platforms

5.1 Introduction

5.2 Business requirements

5.3 Rationale for the bidirectional solution

5.4 Environment configuration

5.5 Step-by-step setup

5.5.1 Step 1: Install WebSphere MQ, WebSphere II with Q replication

5.5.2 Step 2: Determine topology

5.5.3 Step 3: Collect topology and configuration information

5.5.4 Step 4: Set up user IDs, privileges, and database servers

5.5.5 Step 5: Configure WebSphere MQ

5.5.6 Step 6: Configure and activate Q replication using GUI

5.5.7 Step 6: Configure and activate Q replication using commands

5.5.8 Step 7: Set up the Q replication monitoring environment

5.6 Failover considerations

5.7 Switchback considerations

Chapter 6. Peer-to-peer Q replication on AIX platforms

6.1 Introduction

6.2 Business requirements

6.3 Rationale for the peer-to-peer solution

6.4 Environment configuration

6.5 Step-by-step setup

6.5.1 Step 1: Install WebSphere MQ, WebSphere II with Q replication

6.5.2 Step 2: Determine topology.

6.5.3 Step 3: Collect topology and configuration information

6.5.4 Step 4: Set up user IDs, privileges, and database servers

6.5.5 Step 5: Configure WebSphere MQ

6.5.6 Step 6: Configure and activate Q replication using GUI

6.5.7 Step 6: Configure and activate Q replication using commands

6.5.8 Step 7: Set up monitoring environment using the GUI

6.5.9 Step 7: Set up monitoring environment using commands

6.6 Failover considerations

6.7 Switchback considerations

Appendix A. WebSphere MQ overview

WebSphere MQ overview

Messages and queues

WebSphere MQ objects

Clients and servers

Extending queue manager facilities

Security

Transactional support

Q replication objects

Appendix B. Template for topology and configuration information

Introduction

Host and DB2 system information template

WebSphere MQ information template

Q replication configuration information template

Replication Alert Monitor configuration information template

Appendix C. Dead letter queues in a Q replication environment

Dead letter queues overview

Q replication and dead letter queues

Appendix D. Common troubleshooting setup problems

Troubleshooting tools available

AIX operating system

WebSphere MQ

DB2 UDB

Q replication

Basic troubleshooting methodology

Commonly encountered problems

Setup errors

Operational errors

Synchronizing tables

Subscription deactivation

Appendix E. Startup and shutdown scripts for WebSphere MQ and Q replication

Startup and shutdown scripts

Appendix F. Tables used in Q replication scenarios

Tables used in the Q replication scenarios on AIX

Tables used in the Q replication scenarios on z/OS

Appendix G. Communicating with Q replication programs in z/OS

Replication Center script generation and execution.

Replication Center command processing

Unix System Services commands via OMVS

USS commands via batch JCL

Z/OS system commands

Appendix H. Cataloging remote database servers

Cataloging remote database servers in the RC

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Includes bibliographical references (p. 901-902) and index.

OCLC:

61455818