Dbquery – H3C Technologies H3C Intelligent Management Center User Manual

Page 303

Advertising
background image

289

{

Use Template—Select Enable or Disable from the list.

{

Template—Click the

Configure link next to the Template field to select an existing template.

The Template field is automatically populated with the name of the selected template. For more

information about configuring application templates, see "

6 Configuration management

." This

field appears only when you select Enable from the Use Template list.

{

Description—Enter a description for the application monitor.

{

Application Monitor Port—Enter the listening port of PostgreSQL. The default setting is TCP
5432. This field is available only when you select Disable from the Use Template list.

{

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. This field is

available only when you select Disable from the Use Template list.

{

Username—Enter the username of the PostgreSQL administrator. This field is available only
when you select Disable from the Use Template list.

{

Password—Enter the password of the PostgreSQL administrator. This field is available only
when you select Disable from the Use Template list.

{

Contact—Enter the contact information, such as name, email address, and telephone number.
The default is the username of the operator who created the application monitor. This field is

available only when you select Disable from the Use Template list.

{

Related Applications—Click Add next to this filed. On the Select Application dialog box that
appears, select the application that PostgreSQL depends on.

Enter the complete or part of the application monitor name in the Search field at the top of
the page, and click Search.

Select the application that PostgreSQL depends on.

Click OK.

Operating system applications, such as Windows, AIX, SCO UNIX, FreeBSD, OpenBSD,
HP-UX, Solaris, Mac OS, and Linux, cannot be selected. Operators can view all dependencies
of the application in the dependency topology. APM automatically adds the dependencies

between PostgreSQL and operating system applications by IP address and displays their

dependencies in the application topology.
To remove the relationship between PostgreSQL and the specified application, select the
application in the Related Applications field, and then click Delete.

{

Detect Application—Select this parameter if you want to enable application detection. APM
verifies the application connectivity by using the previous parameter settings, and modifies the
application monitor only when it can connect to the application. If you do not select this

parameter, APM modifies the application monitor without verifying the application connectivity.

5.

Click OK.

DBQuery

DBQuery uses SQL statement to query database to judge the database performance through the query

time. Database server error, inappropriate database table design, and excessive large database tables
cause long time to get the query result.
APM supports DBQuery for the following types of databases with different service ports:

MySQL (TCP 3306)

Advertising