HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide

231
 Sybase (TCP 5000)
 SQL Server (TCP 1433)
Adding a DBQuery application monitor
APM monitors the DBQuery application through the port (5000 by default). When you add application
monitors for DBQuery, follow these guidelines:
 Add DBQuery hosts to the IMC Platform so APM can obtain and display network connections of the
hosts and their access devices in the application topology. For more information about adding hosts
to the IMC Platform, see HP IMC Base Platform Administrator Guide.
 Understands the database structure and design SQL statements for key database tables.
 Obtain the username and password of the user who has the database administrator's privileges,
and execute the SQL statements.
 Have knowledge about the database name for MySQL, DB2, Sybase, and SQL Server databases.
Obtain the instance name for Oracle databases, and obtain the non-default instance name for SQL
server that uses non-default instance name.
To add a DBQuery application monitor:
1. Click the Resource tab.
2. Enter the Add Application page in one of the following ways:
 Select Application Manager > Add Application from the navigation tree.
The page displays all application types that can be monitored by APM.
 Select Application Manager > Application Monitor from the navigation tree, and then click Add
on the application monitor list page.
3. Click DBQuery of the Database Server Monitor class.
The page for adding a DBQuery application monitor appears.
4. Configure the following parameters:
 IP Address—Enter the IP address of the host on which the DBQuery application to be monitored
is installed. If the host is already added to the IMC Platform, you can also click Select and select
the host in the Select Devices window. For information about selecting a host, see "2 Quick
start." APM automatically checks the specified IP address and associates the application
monitor with the host managed in the IMC Platform.
 Name—Enter a unique application monitor name. HP recommends using Application
name_host IP address for naming the application monitor.
 Description—Enter a description for the application monitor.
 Port—Enter the port number for the application monitor.
 Polling Interval (min)—Select a polling interval for the application monitor. Available options
include 1, 2, 3, 4, 5, 10, 20, and 30. The default polling interval is 5 minutes. A shorter polling
interval provides more accurate real-time data but consumes more system resources.
 Username—Enter the username of the DBQuery administrator.
 Password—Enter the password of the DBQuery administrator.
 Database Type—Select the database type. Options include MySQL, Oracle, DB2, Sybase, and
SQL Server.
 Database Instance Name—Enter the database name or instance name.