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.