Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

420 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

After a fix is instigated, you can use Optim Configuration Manager to route the

previously misbehaving application transactions back to the fixed application.

Figure 12-4 illustrates Optim Configuration Manager integrated with Optim

Performance to solve a performance issue.

Figure 12-4 Use case 2: Optim Configuration Manager integration with Optim

Performance

12.4 Monitor a DB2 database configuration

In this section we provide an example of using Optim Configuration Manager to

keep track of changes made to the configuration of a DB2 database. This allows

DBAs to keep both historical records and an audit trail of changes made to a

database configuration. This example also illustrates how monitoring a system

can be used to detract changes that can then be applied across a range of

systems to help IT staff to maintain the environment synchronized.

Our data warehousing lab environment consists of two virtual IBM Smart

Analytics Systems built with VMware. The IBM Smart Analytics Systems include

InfoSphere Warehouse Advanced Edition 10.1 and IBM Cognos 10.

We demonstrate the Optim Configuration Manager functions with our lab

systems described in Chapter 3, “Scenario: Warehouse Live Demo Set” on

page 69. For more details about how to manage complex query workload, see

Bad application identified by OPM

Monitor application

and system behavior

Identify the

problematic application

Redirect problematic

application to a backup system

maintained for HA or DR

Review recent configuration

changes to client/server

configurations to determine

root cause

Redirect the tuned

application or workload

back to primary

environment

Fix the problematic

application or tune DB

using existing tools

Use OCM to tune

application configuration

if needed

OCMOPM

OCM

OQWT IDA

DB2 Data

Studio

Chapter 12. InfoSphere Warehouse resilience with Optim Configuration Manager 421

Chapter 6, “Managing complex query workloads in an operational warehouse

environment” on page 237.

In this scenario, we create an Optim Configuration Manager job to monitor

changes on the database server and the database. We then make changes on

the virtual machine, database instance, and database to demonstrate that Optim

Configuration Manager is also capable of or identifying changes made to the

configuration of database.

Follow these steps to create a configuration monitoring job in Optim

Configuration Manager:

1. Create a monitoring job.

Log in to the Optim Configuration Manager web interface. Click Open 

Setup  Job Manager. Click to Add Job. Under type, select Configuration

Management, give a name to the job, and click OK.

Configuration Management is the Optim Configuration Manager job type that

allows you to explore information about your systems, databases, database

servers, and database clients.

Figure 12-5 shows adding a Configuration Management job.

Figure 12-5 Configuration Management job

422 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

2. Specify the monitor objects.

The Job components configuration panel displays. Select the Configuration

management tab to specify the configuration objects to be monitored. You

can use the available templates (Database, Authorization, or Explore), or

select the individual object you want Optim Configuration Manager to monitor.

See Figure 12-6.

Figure 12-6 Properties of the configuration job

In the component configuration panel you can also specify other

characteristics for the configuration monitoring job, such as creating a

schedule, creating a notification rule to send email notifications, or configuring

a job chain. A job chain allows you to string jobs to be executed in sequence,

or to trigger an error handling routine if your job fails.

3. Save and run the monitoring job.

Still in the Optim Configuration Manager web interface, click Open 

Explore  Configuration Changes. This shows a report of what Optim

Configuration Manager found in both system and database. Because this is

the first run, all the data that Optim Configuration Manager found is

considered as inserted items. The Summary tab displays the general

information about the job.

Chapter 12. InfoSphere Warehouse resilience with Optim Configuration Manager 423

Figure 12-7 shows general information about an executed configuration job.

Figure 12-7 Job general information

You can download the generated reports and view the detailed information

gathered by Optim Configuration Manager. The reports contain the