Chapter 7. Monitoring and Reporting

This is the last chapter of the book. In this chapter, we discuss:

• How we can monitor our Q replication setup

• The tools available to report on the setup, for documentation, and trouble-shooting purposes

We will start by looking at what we need to monitor at the three different layers (database layer, WebSphere MQ layer, and Q replication layer). We then go on to discuss the Replication Alert Monitor and other tools to monitor the environment. The chapter concludes with some what if scenarios, some comments on Q replication performance, and a discussion on some common error messages.

The answer to the question What do we need to monitor is almost the same as the answer to the question How long is a piece of string. The simple answer is it depends—which we are sure, will not come as a big surprise to you. What we hope to do in the following sections is—give you a manageable list of items to monitor to cover most situations.