Before you start
IBM now has a Web-based, live monitoring tool that greatly simplifies the task of tracking the health of your Q replication and event publishing environment. The Q Replication Dashboard is part of Version 1.1.2 of the Data Studio Administration Console.
IBM Data Studio Administration Console 1.1.2 is a complementary rich Web interface to help you with the following tasks:
- Monitor the health and availability of IBM DB2® for Linux®, UNIX®, and Windows® (Version 9.5) databases, view dashboard metrics, investigate alert details, and troubleshoot problems using expert recommendations.
- Monitor IBM WebSphere® Replication Server and WebSphere Data Event Publisher (Version 8.2 or later), generate replication health reports, and perform basic replication operations.
The focus of this tutorial is on the Q replication dashboard part of the Data Studio Administration Console.
This tutorial introduces you to the dashboard by providing scripts and batch files to set up a source and two target databases, and to create the Q replication and WebSphere MQ objects to replicate data between them. You will download a small application that generates activity at the source database. Once replication starts, you can use the dashboard to watch the overall health of replication, check performance, and diagnose a problem at one of the targets.
Although the dashboard has many useful monitoring capabilities as Table 1 shows, this tutorial will focus on the following tasks:
- Creating a dashboard view
- Using the health summary
- Tracking latency
- Identifying and diagnosing data exceptions
Q replication health summary
||At-a-glance information on: |
||Live graphs that display latency and throughput statistics|
||Ability to: |
||Ability to: |
Q Capture and Q Apply programs
||Ability to: |
||From any health category: |
After you take this tutorial, you should be able to:
- Use scripts to set up a working Q replication environment
- Create a dashboard view that includes the configurations that you want to monitor
- Use the Summary page to monitor the overall health of replication
- Track replication latency
- Identify and diagnose a data exception
This tutorial should take approximately two hours to finish.
To complete the tutorial, you should have an understanding of Q replication concepts such as source and target servers, control tables, replication queue maps, and Q subscriptions.
You can complete the tutorial on a single Windows computer. The tutorial assumes that your Windows user account has complete access to all DB2 objects through the operating system, which is the default when you install DB2 on Windows. In this case, the user ID is a member of the DB2ADMNS user group.
To learn more about setting up Q replication, see the Q replication tutorial in the Information Management Software for z/OS Solutions Information Center (see Resources).
To take this tutorial, you need the following software installed on a single Windows computer:
- WebSphere Replication Server Version 9.1 or later
- DB2 for Linux, UNIX, and Windows Version 9.1 or later
- WebSphere MQ Version 5.3 or later
- Data Studio Administration Console Version 1.1.2
- Microsoft Windows XP Professional Edition SP2 (32-bit / IA32), Microsoft Windows Server 2003 Standard Edition with R2 SP2 or later (32-bit / IA32), or Microsoft Windows Server 2003 Enterprise Edition with R2 SP2 or later (32-bit / IA32)
To run the tutorial, you need 400MB of free space on the drive where the databases are created and another 150MB free space on the drive from where you invoke the scripts.