To access useful information about the database tier, configure Intelligent Management for performance monitoring.
With database tier performance monitoring, you can view central processing
unit utilization, average response time, and throughput. The information
provided in performance monitoring is valuable for detecting and preventing
bottlenecks.
Before you begin
Ensure that a DB2® or
Oracle database is installed on the node, and the product is installed
with an augmented profile.
About this task
After you have installed either a DB2 or Oracle database on the node and installed
the product with an augmented profile, you can then configure the
database tier for performance monitoring. Monitoring the database
tier provides the information needed to prevent the system from experiencing
slower response time due to bottlenecks.
Procedure
- Create a database server in the WebSphere® Application
Server configuration.
- Create a new generic server and give it a name, for
example DB2Instance1. Select the database node from
the list.
- Click .
- Under Additional properties,
click .
- Add the following entries:
GENERIC_SERVER_TYPE = DBSERVER
GENERIC_SERVER_SUB_TYPE = DB2 (for DB2) or ORACLE (for Oracle)
INSTANCE_NAME = name of database instance (DB2) or SID (Oracle)
- Configure data sources for Java™ Database
Connectivity (JDBC) monitoring:
- Click .
Add
the property: dbServerName = generic server name, for
example, DB2Instance1.
- Follow these steps, depending on the database type and Java database connectivity (JDBC)
driver type you use:
- For type 2 DB2 data sources.
If the database name on the server is different from the database
alias name used on the local DB2 client,
take these actions. For the Database name field
on the Data source configuration panel, specify
the alias name. Under Additional properties, click Custom
property. Add a remote database name custom property,
using database name as the value on the database server.
- For Oracle data sources: If the database name does not display
in the connection URL, under Additional properties, click Custom
property. Set the value of the database name property
to the name of the Oracle database.
- Enable performance monitoring infrastructure (PMI) for
JDBC statistics collection:
- Click
This action displays a list of
servers in the cell.
- For every server in the list that has a data source:
- Click the server name.
- In the Configuration panel, select the Enable
Performance Monitoring Infrastructure (PMI) check box.
Set the Currently monitored statistic set to Extended or All.
However, if the currently monitored statistic set is set to Custom,
and for improved performance, enable the JDBC counters in the Custom
Level.
Results
Your system is now ready for extended monitoring of
Intelligent Management components, including
JDBC. You can view your database from the runtime topology.
What to do next
Read about monitoring the database tier for more information.