 | Level: Intermediate Alice Ma, Architect IM Solutions, Warehousing, IBM
25 Jun 2009 IBM® DB2® Performance Expert Extended Insight
Feature extends the capabilities provided in DB2 Performance Expert by
providing end-to-end database monitoring for Java™ technology
applications, with even more capabilities for those running in IBM
WebSphere® Application Server. This feature gives you the capability to
address performance issues, regardless of where they occur in the software
stack. This tutorial will help you
get started with DB2 Performance Expert Extended Insight Feature. Learn how to install, configure, and validate DB2 Performance Expert Extended
Insight Feature.
Introduction
DBAs today must deal with complex performance problems that often
require insights beyond those provided by monitoring tools that focus
solely on database interactions. Java technology database applications
are often part of complex, multi-tiered environments in which it can
take hours, days, or more to solve a problem and require the input of
IT staff in other areas, such as networking and applications. DBAs
need a way to gain insight into database performance as it relates to
other layers in the software stack so they have the information they
need to find and fix problems quickly, whether the problem is in the
database or somewhere else.
DB2 Performance Expert Extended Insight Feature extends the
capabilities provided in DB2 Performance Expert by providing
end-to-end database monitoring for Java technology applications, with
even more capabilities for those running in WebSphere Application
Server. It can provide insight into any stop along the software stack,
from when the SQL is issued from the application, through the
application server, database server, and operating system. It provides
insight into response times that are closer to what end users are
experiencing, and it provides valuable information to pass on to
network and applications administrators when their help is required to
fix a problem.
For more information on the power of Performance Expert Extended
Insight Feature, see Resources.
About this tutorial
After a discussion of sample configurations, this tutorial walks you
through installing, configuring, and validating the DB2 Performance
Expert Extended Insight Feature. The main steps include the
following:
- Verify you have the right prerequisites
- Install the software on the necessary servers
- Activate the Performance Expert Extended Insight Feature
- Optional: Enable Performance Expert Extended Insight with
WebSphere Application Server
- Configure the Performance Expert client to recognize the Extended
Insight Feature
- Run a workload to validate that data is being collected
Prerequisites
This tutorial assumes you have a Java technology database application
you want to monitor. To install Performance Expert Extended Insight
Feature 3.2, you need the following installed on Microsoft®
Windows® or UNIX®:
The differences between Windows and UNIX are highlighted throughout the
tutorial.
| |
