Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

246 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Within Optim Performance Manager, you can look at metrics for a set of

database partitions or for an individual database partition. This feature is made

available on dashboards through the role drop-down box as shown in Figure 6-6.

Figure 6-6 Filtering dashboard metrics by role

6.2.1 Collecting large volumes of performance metrics

If you modify the monitoring configuration to collect additional performance

metrics, the default table space can become full before the data gets written back

to the Optim Performance Manager repository database.

To avoid the default table space becoming full and data collection being

disabled, create a separate 32 K table space for event monitors, as follows:

1. Create a table space across each data module by using the following sample

statement, where OPMPG is the database partition group:

CREATE DATABASE PARTITION GROUP OPMPG ON ALL DBPARTITIONNUMS

CREATE BUFFERPOOL OPM32KBP DATABASE PARTITION GROUP OPMPG PAGESIZE 32K

NUMBLOCKPAGES 100000 BLOCKSIZE 16;

CREATE TABLESPACE OPMTS IN OPMPG PAGESIZE 32K BUFFERPOOL OPM32KBP OVERHEAD

4.0 TRANSFERRATE 0.04

Choose the media attribute values for OVERHEAD and TRANSFERRATE to

reflect the storage media in your environment. The values used in this

example are for illustration purposes.

2. Configure Optim Performance Manager to use the new table space:

On the Database dashboard, click Configure Monitoring to access the Edit

Monitoring Configuration wizard for the monitored database. Change the DB2

event monitor configuration by using Step 2 of the wizard. To change the DB2

event monitor configuration, click the edit icon.

Click Use custom table space and from the list, select the table space that

you created in step 1.