Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

444 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

In our example, after we selected our data migration log and clicked View log

in the web browser, we saw that a table space aged and was moved to the

Cold storage group. See Figure 12-34.

Figure 12-34 Optim Configuration Manager data migration job log

With the Optim Configuration Manager data migration job, DBAs automate a

recurrent and time-consuming task. The job can also send notifications and can

be configured to run before or after other jobs.

12.7 InfoSphere Warehouse high availability with

Q replication and Optim Configuration Manager

Optim Configuration Manager can be used to redirect client applications from

one system to another. When combined with a replication solution such as

Q replication, it helps improve reliability, fault-tolerance, performance, and

accessibility in a simplified manner.

Chapter 12. InfoSphere Warehouse resilience with Optim Configuration Manager 445

Q Replication is a solution that uses WebSphere MQ message queues to

transmit transactions between source and target databases. This type of

replication offers several benefits:

򐂰 Minimum latency - Changes are sent as soon as they are committed at the

source and read from the log.

򐂰 High volume throughput - WebSphere Q Capture and Q Apply programs use

a multithreaded architecture to cope with rapid changes at the source.

򐂰 Minimum network traffic - Messages are sent by using a compact format and

only necessary information is sent through the network.

򐂰 Asynchronous communication - In case of a system failure, messages remain

in the queue and are processed when the system is able to handle new

requests again. This is based on the fact that both Q Apply and Q Capture

programs can operate independently in an asynchronous mode.

With Q Replication, the target or standby database is available for read and write

access. This means that you can offload processes to the standby database,

thus relieving the production environments.

Q Replication allows many different configurations. You can replicate between

remote servers or within a single server. You can replicate changes in a single

direction or in multiple directions. Replicating in multiple directions can be

bidirectional (useful for managing standby or backup systems) or peer-to-peer

(useful for synchronizing data on production systems).

Q Replication supports three types of replication:

򐂰 Unidirectional replication

򐂰 Bidirectional replication

򐂰 Peer-to-peer replication

In this section, we demonstrate how to set up a unidirectional replication of a

database by using three products:

򐂰 WebSphere MQ - to create the queues

򐂰 IBM Replication Center - to create the replication rules

򐂰 Optim Configuration Manager - to redirect client applications

All of these products are shipped with InfoSphere Warehouse Advanced Edition.

Create queues with WebSphere MQ

Follow these steps to create WebSphere MQ objects:

1. Open WebSphere MQ.

446 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Figure 12-35 shows WebSphere MQ initial panel.

Figure 12-35 WebSphere MQ initial panel

2. Create queue managers.

We have to create queue managers for both source and the target databases.

Right-click Queue Managers and select New  Queue Manager.

Figure 12-36 shows two queue managers are created, SRC-QM for the

source database and TGR_QM for the target database.

Figure 12-36 Queue managers created