Enabling DB2 Performance Expert Extended Insight

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:

About this task

New feature New feature: 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.newfeat
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

  1. Log into the administrative console.
  2. Click Resources > JDBC > JDBC Providers > JDBC_provider .
  3. Update the class path for the data source with the pdq.jar file for PEEI. Type the names for the following JAR file:
    • pdq.jar
    Avoid trouble 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
  4. Click OK.
  5. Save the configuration.
  6. Add the enableEndToEndMonitoringFeature custom property for the DB2 data source. The PEEI feature is disabled by default, and PEEI is controlled by the enableEndToEndMonitoringFeature custom property, which has a default of false.
    1. Navigate to Resources > JDBC > JDBC Providers > JDBC_provider .
    2. Click Data sources.
    3. Click the name of the data source.
    4. Click Custom properties.
    5. Click New and enter the values for the enableEndToEndMonitoringFeature custom property. Enter the following values:
      Table 1. enableEndToEndMonitoringFeature custom property
      Name Value
      enableEndToEndMonitoringFeature true
    6. Click OK.
    7. Save the configuration.
  7. Restart Application Server.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 2:56:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-dist&topic=tdat_db2peei
File name: tdat_db2peei.html