WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios

WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios

by Nagraj Alur, Rich Briddell, Donna Kelsey, Naoko Takaya
Released April 2005
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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.

Table of contents

  1. Figures (1/3)
  2. Figures (2/3)
  3. Figures (3/3)
  4. Tables
  5. Notices
    1. Trademarks
  6. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  7. Chapter 1: Introduction to replication technologies
    1. Business of replication
    2. Replication options
    3. Asynchronous replication options
    4. IBM product offerings (1/2)
    5. IBM product offerings (2/2)
    6. SQL replication, Q replication, and HADR comparison
  8. Chapter 2: WebSphere Information Integrator Q replication overview
    1. Q replication overview
      1. Unidirectional replication
      2. Bidirectional replication
      3. Peer-to-peer replication
      4. Replication Alert Monitor
    2. Q replication processing flow
      1. Initial synchronization of the data at the source and target (1/2)
      2. Initial synchronization of the data at the source and target (2/2)
      3. Ongoing replication after the initial synchronization (1/2)
      4. Ongoing replication after the initial synchronization (2/2)
    3. Choosing a particular Q replication topology
    4. Best practices considerations
      1. Q Capture considerations
      2. Replication queue map considerations (1/2)
      3. Replication queue map considerations (2/2)
      4. Q Apply considerations
      5. WebSphere MQ considerations (1/2)
      6. WebSphere MQ considerations (2/2)
      7. Latency considerations (1/3)
      8. Latency considerations (2/3)
      9. Latency considerations (3/3)
  9. Chapter 3: Bidirectional Q replication on z/OS platforms
    1. Introduction
    2. Business requirement
    3. Rationale for the bidirectional solution
    4. Environment configuration
    5. Step-by-step setup
      1. Step 1: Install WebSphere MQ, WebSphere II with Q replication (1/2)
      2. Step 1: Install WebSphere MQ, WebSphere II with Q replication (2/2)
      3. Step 2: Determine topology
      4. Step 3: Collect topology and configuration information
      5. Step 4: Set up user IDs, privileges, and database servers (1/3)
      6. Step 4: Set up user IDs, privileges, and database servers (2/3)
      7. Step 4: Set up user IDs, privileges, and database servers (3/3)
      8. Step 5: Configure WebSphere MQ (1/2)
      9. Step 5: Configure WebSphere MQ (2/2)
      10. Step 6: Configure and activate Q replication using GUI (1/17)
      11. Step 6: Configure and activate Q replication using GUI (2/17)
      12. Step 6: Configure and activate Q replication using GUI (3/17)
      13. Step 6: Configure and activate Q replication using GUI (4/17)
      14. Step 6: Configure and activate Q replication using GUI (5/17)
      15. Step 6: Configure and activate Q replication using GUI (6/17)
      16. Step 6: Configure and activate Q replication using GUI (7/17)
      17. Step 6: Configure and activate Q replication using GUI (8/17)
      18. Step 6: Configure and activate Q replication using GUI (9/17)
      19. Step 6: Configure and activate Q replication using GUI (10/17)
      20. Step 6: Configure and activate Q replication using GUI (11/17)
      21. Step 6: Configure and activate Q replication using GUI (12/17)
      22. Step 6: Configure and activate Q replication using GUI (13/17)
      23. Step 6: Configure and activate Q replication using GUI (14/17)
      24. Step 6: Configure and activate Q replication using GUI (15/17)
      25. Step 6: Configure and activate Q replication using GUI (16/17)
      26. Step 6: Configure and activate Q replication using GUI (17/17)
      27. Step 6: Configure and activate Q replication using commands (1/8)
      28. Step 6: Configure and activate Q replication using commands (2/8)
      29. Step 6: Configure and activate Q replication using commands (3/8)
      30. Step 6: Configure and activate Q replication using commands (4/8)
      31. Step 6: Configure and activate Q replication using commands (5/8)
      32. Step 6: Configure and activate Q replication using commands (6/8)
      33. Step 6: Configure and activate Q replication using commands (7/8)
      34. Step 6: Configure and activate Q replication using commands (8/8)
      35. Step 7: Set up monitoring environment using GUI (1/9)
      36. Step 7: Set up monitoring environment using GUI (2/9)
      37. Step 7: Set up monitoring environment using GUI (3/9)
      38. Step 7: Set up monitoring environment using GUI (4/9)
      39. Step 7: Set up monitoring environment using GUI (5/9)
      40. Step 7: Set up monitoring environment using GUI (6/9)
      41. Step 7: Set up monitoring environment using GUI (7/9)
      42. Step 7: Set up monitoring environment using GUI (8/9)
      43. Step 7: Set up monitoring environment using GUI (9/9)
      44. Step 7: Set up monitoring environment using commands (1/4)
      45. Step 7: Set up monitoring environment using commands (2/4)
      46. Step 7: Set up monitoring environment using commands (3/4)
      47. Step 7: Set up monitoring environment using commands (4/4)
    6. Failover considerations
    7. Switchback considerations
  10. Chapter 4: Peer-to-peer Q replication on z/OS platforms
    1. Introduction
    2. Business requirement
    3. Rationale for the peer-to-peer solution
    4. Environment configuration
    5. Step-by-step setup
      1. Step 1: Install WebSphere MQ, WebSphere II with Q replication
      2. Step 2: Determine topology
      3. Step 3: Collect topology and configuration information
      4. Step 4: Set up user IDs, privileges, and database servers
      5. Step 5: Configure WebSphere MQ
      6. Step 6: Configure and activate Q replication using GUI
      7. Step 6: Configure and activate Q replication using commands (1/8)
      8. Step 6: Configure and activate Q replication using commands (2/8)
      9. Step 6: Configure and activate Q replication using commands (3/8)
      10. Step 6: Configure and activate Q replication using commands (4/8)
      11. Step 6: Configure and activate Q replication using commands (5/8)
      12. Step 6: Configure and activate Q replication using commands (6/8)
      13. Step 6: Configure and activate Q replication using commands (7/8)
      14. Step 6: Configure and activate Q replication using commands (8/8)
      15. Step 7: Set up monitoring environment using the GUI
    6. Failover considerations
    7. Switchback considerations
  11. Chapter 5: Bidirectional Q replication on AIX platforms
    1. Introduction
    2. Business requirements
    3. Rationale for the bidirectional solution
    4. Environment configuration
    5. Step-by-step setup
      1. Step 1: Install WebSphere MQ, WebSphere II with Q replication
      2. Step 2: Determine topology
      3. Step 3: Collect topology and configuration information
      4. Step 4: Set up user IDs, privileges, and database servers (1/2)
      5. Step 4: Set up user IDs, privileges, and database servers (2/2)
      6. Step 5: Configure WebSphere MQ (1/3)
      7. Step 5: Configure WebSphere MQ (2/3)
      8. Step 5: Configure WebSphere MQ (3/3)
      9. Step 6: Configure and activate Q replication using GUI (1/16)
      10. Step 6: Configure and activate Q replication using GUI (2/16)
      11. Step 6: Configure and activate Q replication using GUI (3/16)
      12. Step 6: Configure and activate Q replication using GUI (4/16)
      13. Step 6: Configure and activate Q replication using GUI (5/16)
      14. Step 6: Configure and activate Q replication using GUI (6/16)
      15. Step 6: Configure and activate Q replication using GUI (7/16)
      16. Step 6: Configure and activate Q replication using GUI (8/16)
      17. Step 6: Configure and activate Q replication using GUI (9/16)
      18. Step 6: Configure and activate Q replication using GUI (10/16)
      19. Step 6: Configure and activate Q replication using GUI (11/16)
      20. Step 6: Configure and activate Q replication using GUI (12/16)
      21. Step 6: Configure and activate Q replication using GUI (13/16)
      22. Step 6: Configure and activate Q replication using GUI (14/16)
      23. Step 6: Configure and activate Q replication using GUI (15/16)
      24. Step 6: Configure and activate Q replication using GUI (16/16)
      25. Step 6: Configure and activate Q replication using commands (1/3)
      26. Step 6: Configure and activate Q replication using commands (2/3)
      27. Step 6: Configure and activate Q replication using commands (3/3)
      28. Step 7: Set up the Q replication monitoring environment
    6. Failover considerations
    7. Switchback considerations
  12. Chapter 6: Peer-to-peer Q replication on AIX platforms
    1. Introduction
    2. Business requirements
    3. Rationale for the peer-to-peer solution
    4. Environment configuration
    5. Step-by-step setup
      1. Step 1: Install WebSphere MQ, WebSphere II with Q replication
      2. Step 2: Determine topology
      3. Step 3: Collect topology and configuration information
      4. Step 4: Set up user IDs, privileges, and database servers (1/2)
      5. Step 4: Set up user IDs, privileges, and database servers (2/2)
      6. Step 5: Configure WebSphere MQ (1/3)
      7. Step 5: Configure WebSphere MQ (2/3)
      8. Step 5: Configure WebSphere MQ (3/3)
      9. Step 6: Configure and activate Q replication using GUI (1/17)
      10. Step 6: Configure and activate Q replication using GUI (2/17)
      11. Step 6: Configure and activate Q replication using GUI (3/17)
      12. Step 6: Configure and activate Q replication using GUI (4/17)
      13. Step 6: Configure and activate Q replication using GUI (5/17)
      14. Step 6: Configure and activate Q replication using GUI (6/17)
      15. Step 6: Configure and activate Q replication using GUI (7/17)
      16. Step 6: Configure and activate Q replication using GUI (8/17)
      17. Step 6: Configure and activate Q replication using GUI (9/17)
      18. Step 6: Configure and activate Q replication using GUI (10/17)
      19. Step 6: Configure and activate Q replication using GUI (11/17)
      20. Step 6: Configure and activate Q replication using GUI (12/17)
      21. Step 6: Configure and activate Q replication using GUI (13/17)
      22. Step 6: Configure and activate Q replication using GUI (14/17)
      23. Step 6: Configure and activate Q replication using GUI (15/17)
      24. Step 6: Configure and activate Q replication using GUI (16/17)
      25. Step 6: Configure and activate Q replication using GUI (17/17)
      26. Step 6: Configure and activate Q replication using commands (1/2)
      27. Step 6: Configure and activate Q replication using commands (2/2)
      28. Step 7: Set up monitoring environment using the GUI (1/9)
      29. Step 7: Set up monitoring environment using the GUI (2/9)
      30. Step 7: Set up monitoring environment using the GUI (3/9)
      31. Step 7: Set up monitoring environment using the GUI (4/9)
      32. Step 7: Set up monitoring environment using the GUI (5/9)
      33. Step 7: Set up monitoring environment using the GUI (6/9)
      34. Step 7: Set up monitoring environment using the GUI (7/9)
      35. Step 7: Set up monitoring environment using the GUI (8/9)
      36. Step 7: Set up monitoring environment using the GUI (9/9)
      37. Step 7: Set up monitoring environment using commands (1/2)
      38. Step 7: Set up monitoring environment using commands (2/2)
    6. Failover considerations
    7. Switchback considerations
  13. Appendix A: WebSphere MQ overview
    1. WebSphere MQ overview
      1. Messages and queues
      2. WebSphere MQ objects (1/2)
      3. WebSphere MQ objects (2/2)
      4. Clients and servers
      5. Extending queue manager facilities
      6. Security
      7. Transactional support
    2. Q replication objects
  14. Appendix B: Template for topology and configuration information
    1. Introduction
    2. Host and DB2 system information template
    3. WebSphere MQ information template
    4. Q replication configuration information template
    5. Replication Alert Monitor configuration information template
  15. Appendix C: Dead letter queues in a Q replication environment
    1. Dead letter queues overview
    2. Q replication and dead letter queues
  16. Appendix D: Common troubleshooting setup problems
    1. Troubleshooting tools available
      1. AIX operating system
      2. WebSphere MQ
      3. DB2 UDB
      4. Q replication
    2. Basic troubleshooting methodology
    3. Commonly encountered problems
      1. Setup errors
      2. Operational errors (1/2)
      3. Operational errors (2/2)
    4. Synchronizing tables
    5. Subscription deactivation
  17. Appendix E: Startup and shutdown scripts for WebSphere MQ and Q replication
    1. Startup and shutdown scripts
  18. Appendix F: Tables used in Q replication scenarios
    1. Tables used in the Q replication scenarios on AIX (1/2)
    2. Tables used in the Q replication scenarios on AIX (2/2)
    3. Tables used in the Q replication scenarios on z/OS (1/17)
    4. Tables used in the Q replication scenarios on z/OS (2/17)
    5. Tables used in the Q replication scenarios on z/OS (3/17)
    6. Tables used in the Q replication scenarios on z/OS (4/17)
    7. Tables used in the Q replication scenarios on z/OS (5/17)
    8. Tables used in the Q replication scenarios on z/OS (6/17)
    9. Tables used in the Q replication scenarios on z/OS (7/17)
    10. Tables used in the Q replication scenarios on z/OS (8/17)
    11. Tables used in the Q replication scenarios on z/OS (9/17)
    12. Tables used in the Q replication scenarios on z/OS (10/17)
    13. Tables used in the Q replication scenarios on z/OS (11/17)
    14. Tables used in the Q replication scenarios on z/OS (12/17)
    15. Tables used in the Q replication scenarios on z/OS (13/17)
    16. Tables used in the Q replication scenarios on z/OS (14/17)
    17. Tables used in the Q replication scenarios on z/OS (15/17)
    18. Tables used in the Q replication scenarios on z/OS (16/17)
    19. Tables used in the Q replication scenarios on z/OS (17/17)
  19. Appendix G: Communicating with Q replication programs in z/OS
    1. Introduction
    2. Replication Center script generation and execution
    3. Replication Center command processing
    4. Unix System Services commands via OMVS
    5. USS commands via batch JCL
    6. Z/OS system commands
  20. Appendix H: Cataloging remote database servers
    1. Cataloging remote database servers in the RC (1/4)
    2. Cataloging remote database servers in the RC (2/4)
    3. Cataloging remote database servers in the RC (3/4)
    4. Cataloging remote database servers in the RC (4/4)
  21. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  22. Index (1/3)
  23. Index (2/3)
  24. Index (3/3)
  25. Back cover

Product information

  • Title: WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
  • Author(s): Nagraj Alur, Rich Briddell, Donna Kelsey, Naoko Takaya
  • Release date: April 2005
  • Publisher(s): IBM Redbooks
  • ISBN: None