WebSphere information integrator Q replication : fast track implementation scenarios

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 for exploiting its high throughput, low latency, and other capabilities in the design and implementation of high-availability and high-performance distributed business soluti...

Descripción completa

Detalles Bibliográficos
Autor principal: Alur, Nagraj (-)
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Jose, CA : IBM, International Technical Support Organization 2005.
Edición:1st ed
Colección:IBM redbooks.
Materias:
WebSphere.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626918606719
Tabla de Contenidos:
  • 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
  • Introduction
  • 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.

Ejemplares similares