Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 6. Managing complex query workloads in an operational warehouse environment 245

6.2 Optim Performance Manager in a partitioned

database environment

Managing query workloads in a partitioned data warehouse database means that

you have to interpret multiple sets of metrics across database partitions and

often across multiple data nodes.

In a partitioned database environment, by default, data in Optim Performance

Manager is displayed as an average across all database partitions for which data

is being collected. When this data includes data for the coordinator partition, the

metrics might appear skewed.

Step 5 of the Edit Monitoring Configuration wizard allows you to assign a role to

each database partition in the partitioned database. These roles can be used in

the Optim Performance Manager dashboards to filter data by a specific set of

database partitions, also referred to as members. This eliminates the coordinator

partition from the metrics you are viewing.

Figure 6-5 shows the role assigned to each database partition in a test

environment that contained a single coordinator partition and four database

partitions. You can also include ETL partitions, catalog partitions, and other

roles.

Figure 6-5 Assigning a role to each database partition in your database