Db2

This paper is targeted at those who are involved in implementing IBM InfoSphere Optim Performance Manager (OPM) 5.1 in a data warehouse environment that is based on DB2® for Linux, UNIX, and Windows V9.7 (DB2 9.7) software. In particular, this paper focuses on the IBM ®Smart Analytics System environment with configurations that are based on System x® and Power SystemsTM servers. This paper describes an OPM monitoring configuration that takes advantage of the in‐memory metrics that were released in DB2 9.7.

The goal of an OPM implementation in a warehouse environment is to identify which database operations and application workloads are consuming resources on individual database partitions and across the entire database. Identifying the appropriate indicators and workloads to monitor in your environment is a key step in measuring the performance of your database workloads against your service level objectives.

To diagnose possible performance bottlenecks and trends in database workload behavior, you can use dashboards and reports in OPM. In particular, you can use the dashboards and reports to help perform root cause analysis for locking conflicts, deadlocks, timeouts, log performance problems, resource shortages, and sorting problems.

The IBM Smart Analytics System product incorporates best practices guidelines for a stable and high‐performance data warehouse environment and is based on a shared‐ nothing architecture. This paper builds on that approach by recommending how you can use OPM to monitor database performance and identify deviations in behavior across the database.


Introduction

OPM is a highly configurable application that you can use to monitor the health and performance of a database. Follow the recommendations in this paper to help you optimize the configuration of OPM to efficiently monitor and manage data queries, data loads, and administrative operations with OPM’s diagnostic dashboards and reports. You can use these dashboards and reports to diagnose possible performance bottlenecks and trends in database workload behavior. In particular, you can use the dashboards and reports to help determine the cause of locking conflicts, deadlocks, timeouts, log performance problems, resource shortages, and sorting problems.

The first part of the paper describes how OPM is installed and configured in IBM Smart Analytics System 7700 R1 environment and how you can modify the configuration to suit your needs.

After the installation and configuration steps, the paper describes how to use OPM to monitor performance metrics in a data warehouse environment. You will also learn how you can configure alert thresholds to align them with service level objectives and to notify you of any exceptions.

Finally, you will learn how you can use OPM with DB2 Workload Manager (DB2 WLM) best practices to monitor metrics by application workload.

Publications that explain how the product is installed, set up, and used in various environments are referenced in the “Further reading” section. This paper complements these publications and focuses on warehousing environments in general and the IBM Smart Analytics System in particular.

Download the report to get started!