 | Level: Intermediate Dell Burner (dellb@us.ibm.com), Lead writer, WebSphere Replication Server, IBM
Tanya Couch (couch@us.ibm.com), Team lead, Q Replication Dashboard development, IBM
27 Mar 2008 The Q Replication Dashboard is a part of the IBM® Data Studio
Administration Console that helps you monitor and manage the health of Q replication
and event publishing. In this tutorial, quickly set up a working replication
environment, and use the dashboard to view latency and throughput, spot problems,
and analyze performance. Objectives - 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.
Prerequisites
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 (link
included in the tutorial's Resources section).
System requirements
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.
Duration
Formats html, pdf
Tutorial overview
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.
| | | |
