Before you can capture database performance
data for SQL statements that are run from a Java application in the workbench, you must
configure your Java project.
After you capture the performance data, you can import and view the
performance data in the SQL Outline view.
The
application must run the SQL statements on a database that is monitored
by InfoSphere® Optim™ Performance Manager Extended
Edition.
Before you begin
Ensure that the following requirements are met:
- The Java project must have
Data Access Development support enabled to view imported performance
data in the SQL Outline view. If your project
has pureQuery support, it has Data Access Development support.
- When you run your application, the classpath must contain the
pureQuery JAR files pdq.jar and pdqmgmt.jar.
- Your database application must run SQL statements dynamically.
- If you are using the pureQuery API in your application, you must
use pureQuery inline methods or pureQuery interfaces to run the SQL
statements.
- The SQL statements must run on a database that is monitored by InfoSphere Optim Performance Manager Extended
Edition.
- For the installation of InfoSphere Optim Performance Manager that is monitoring
the database, you must know the URL of the computer and the port used
by InfoSphere Optim Performance Manager Extended
Insight.
About this task
In your Java project,
you set the pdq.cmx.controllerURL property in the properties file pdq.properties,
The property specifies the computer running InfoSphere Optim Performance Manager and the port used
by InfoSphere Optim Performance Manager Extended
Edition.
The
properties file is also used by pureQuery Runtime if your project
is enabled with pureQuery support.
Procedure
To enable database performance monitoring of SQL statements:
- If needed, create the text file pdq.properties in
the source directory of your project. For a Java project that is using the default source
directory src/, create the file src/pdq.properties.
If
your project is enabled with pureQuery support, the file might exist
in the source directory.
- Add the pdq.cmx.controllerURL property
and value to the properties file for your project.
The
value of the property in the properties file of your project must
match the value of the property for the InfoSphere Optim Performance Manager installation that
is monitoring the database.
In the following properties file
example, the value of
pdq.cmx.controllerURL property
is
PERFMON.test.systems:60000:
pdq.cmx.controllerURL=PERFMON.test.systems:60000
pdq.captureMode=ON
pdq.executionMode=DYNAMIC
pdq.pureQueryXml=dataAccessFolder/capture.pdqxml
The value
is the URL of the computer (
PERFMON.test.systems)
and the
InfoSphere Optim Performance Manager extended
insight port (
60000) for the installation of
InfoSphere Optim Performance Manager.
The other
properties in the file are pureQuery Runtime properties.
- Run the Java application.
Results
When you run your application, it runs as an Extended Insight
client for InfoSphere Optim Performance Manager.
SQL performance data is captured and stored in the InfoSphere Optim Performance Manager repository database.
You
can import the performance data and view the data in the SQL
Outline view.
You can view the SQL performance data
that is in the repository database with InfoSphere Optim Performance Manager. Log on to the InfoSphere Optim Performance Manager installation that
is monitoring your database. From the Extended Insight Analysis
Dashboard, select your monitored database and view performance
information. The performance data for SQL statements are displayed
as dashboard details.