If you have a DB2 database configured in the Application
Server, enable DB2 Performance Expert Extended Insight (PEEI) to employ
an end-to-end monitoring system for your environment. PEEI features
allow you to monitor transactions throughout your system stack and
tune your resources according to the comprehensive data reports.
Before you begin
Ensure that you meet the following preconditions:
- You must have a backend database with at least version 9.1 of
DB2 for Linux, HP-UX, Solaris, or Windows.
- Install fix pack 6 for DB2 Version 9.1.
If you use a version earlier than fix pack 6, server time statistics
are not provided.
- Use Version 3.53.x, including DB2 APAR IZ35480, or later of the
DB2 Using IBM JCC Driver or the DB2 Universal JDBC Driver provider.
- Application Server is updated to Version 7.0.0.1.
About this task
DB2 Performance Expert Extended Insight (PEEI) allows
you to monitor, identify, and resolve performance issues for your
entire stack and not just the database layer. These features provide
results with a granularity to accurately pinpoint the cause and the
culprit of the issue, allowing you to quickly resolve the problem
and minimize downtime for your environment.
When you integrate
PEEI monitoring features with Application Server, you will be able
to answer the following questions:
- Are my clients configured properly and synchronized with my data
servers?
- Is my connection pooling setup sufficient?
- What are the constraints for my clients' system resources?
- What are the top clients, users, applications, SQLs, etc., for
my environment?
- Is my network capacity sufficient?
- Which resource consumes most of my network?
Procedure
- Log into the administrative console.
- Click .
- Update the class path for the data source with the pdq.jar
file for PEEI. Type the names for the following JAR
file:
Avoid trouble: Class path entries are separated by
using the ENTER key and must not contain path separator characters
(such as ';' or ':'). Class paths can contain variable (symbolic)
names that can be substituted using a variable map.
gotcha
- Click OK.
- Save the configuration.
- Remove the enableEndToEndMonitoringFeature custom property
for the DB2 data source, if it exists.
- Navigate to .
- Click Data sources.
- Click the name of the data source.
- Click Custom properties.
- Select the enableEndToEndMonitoringFeature custom property
from the list and select Delete.
- Click OK.
- Save the configuration.
- Restart Application Server.
What to do next
PEEI is enabled by default when you configure the JDBC provider
with the JAR file. To control the end-to-end monitoring feature, you
can configure a custom property to control the monitoring feature:
- Navigate to .
- Click Data sources.
- Click the name of the data source.
- Click Custom properties.
- Click New and enter the following property:
Table 1. disableEndToEndClientMonitoringFeature custom property. Set the property value to true.Name |
Value |
disableEndToEndClientMonitoringFeature |
true |