Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
IBM InfoSphere Replication Server and Data Event Publisher

You're reading from  IBM InfoSphere Replication Server and Data Event Publisher

Product type Book
Published in Aug 2010
Publisher Packt
ISBN-13 9781849681544
Pages 344 pages
Edition 1st Edition
Languages
Concepts
Authors (2):
Pav Kumar-Chatterjee Pav Kumar-Chatterjee
Profile icon Pav Kumar-Chatterjee
Pav Kumar Chatterjee Pav Kumar Chatterjee
Profile icon Pav Kumar Chatterjee
View More author details

Table of Contents (12) Chapters

IBM InfoSphere Replication Server and Data Event Publisher
Credits
About the Author
About the Reviewer
1. Preface
1. Q Replication Overview 2. Q Replication Components 3. The DB2 Database Layer 4. WebSphere MQ for the DBA 5. The ASNCLP Command Interface 6. Administration Tasks 7. Monitoring and Reporting

Some what happens if ... scenarios


What we look at in the following sections are some common what if questions. For each scenario, the repercussions are examined for an active Q subscription when a record is inserted.

If MQ is stopped on each server

What we will test in this section is what happens if the Queue Manager is stopped. We will test this using unidirectional replication (Refer to Appendix A for details on how to set up unidirectional replication).

  1. 1. First let's make sure that replication is working. From CLP-A, issue:

    $ db2 "insert into eric.t1 values (5,5,'H')"

    From CLP-B, issue:

    $ db2 "select * from fred.t1"
    C1 C2 C3
    ----------- ----------- ----------
    5 5 H
    1 record(s) selected.

    We should see one record in FRED.T1 on DB2B.

    We can see that the unidirectional Q replication setup is working.

  2. 2. Now we can continue with our test. Stop the WebSphere MQ on the source server.

    $ endmqm -p QMA

    WebSphere MQ queue manager 'QMA' ending.

    WebSphere MQ queue manager 'QMA' ended.

    Is the Q subscription...

lock icon The rest of the chapter is locked
arrow left Previous Chapter
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}