Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

436 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

By configuring jobs within Optim Configuration Manager to monitor databases,

you can detect opportunities to reclaim the trapped storage, apply compression,

or drop seldom-used tables and indexes.

You can optimize the use of your storage devices by implementing a

multi-temperature storage solution. With a multi-temperature storage solution,

the data that you expect to access most frequently is kept on fast storage, while

keeping the data that is accessed infrequently on slower and cheaper devices.

Optim Configuration Manager can be configured to schedule jobs that will move

your data from high performance storage to the slower devices, thereby reducing

the need for DBAs to be involved in these administrative duties.

12.6.1 Example Optim Configuration Manager storage-saving job

The example provided in this section demonstrates how to create and schedule a

storage monitoring job to find opportunities to reduce storage consumption.

Follow these steps to configure an Optim Configuration Manager job to monitor

the storage usage of your warehouse database:

1. Define a connection to the database you want to monitor.

Start the Optim Configuration Manager web interface. Click Open 

Setup  Databases. Click Add and fill the fields with the database

information; see Figure 12-23.

Figure 12-23 Creating a database connection

Chapter 12. InfoSphere Warehouse resilience with Optim Configuration Manager 437

2. Add a monitoring job.

After the database connection is created, click Open  Setup  Job

Manager. Click Add Job; see Figure 12-24.

Figure 12-24 Adding a monitoring job

3. Select the job type.

Select Storage monitoring as the job type; see Figure 12-25.

Storage monitoring is the Optim Configuration Manager job that looks for

opportunities to reclaim trapped storage in tables, identify tables and indexes

where compression can be applied, and drop seldom-used databases objects

(tables and indexes, for example). Click OK.

Figure 12-25 Create a Storage monitoring job

4. Select the monitoring tasks.

After clicking OK to add the job, you are redirected to the components

configuration of the job automatically. Go to the Properties tab.

The Storage monitoring job can perform three tasks:

– Find reclaimable storage -This job looks for storage allocated but not

used.

438 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

– Find compression opportunities - This job looks for tables without

compression enabled.

– Track frequency of use and identify seldom used objects - This job looks

for database objects that are seldom used. If these objects are no longer

required, the DBA can delete them to save storage.

You can select any or all tasks; see Figure 12-26. We suggest that you select

all three tasks for your monitor job because each one has certain

characteristics, but are complementary to each other in the search for

opportunities to optimize storage.

Figure 12-26 Selecting tasks to monitor

5. Set the storage monitoring job schedule.

While still in the component configuration, click the Schedule tab. The

Schedule tab has three subtabs:

– Schedule Details tab - In this tab, you set up the job frequency.

– The Database tab - In this tab, you select the databases on which to run

the job. You can select one or multiple databases.

– Timeout Settings tab - In this tab, you specify an action to take if the script

execution duration exceeds a timeout period.