Database information, Row statistics, Cache performance – H3C Technologies H3C Intelligent Management Center User Manual

Page 295

Advertising
background image

281

Database Information

The Database Information area layout is shown in

Figure 234

.

Figure 234 Database Information area layout

Database Information area fields:

•

Database Name—Name of the database.

•

Alias—Alias of the database.

•

Path—Complete path for storing the database in the operating system.

•

Status—Database state when APM last polled DB2.

•

Connection Time—Most recent time when the database finished processing a connection request

when APM last polled DB2.

•

Sort Overflow(%)—How often the sort overflow occurred when APM last polled DB2.

•

Deadlocks—Times of deadlocks that occurred when APM last polled DB2.

•

Log Usage—Database log usage ratio when APM last polled DB2.

Row Statistics

The Row Statistics area layout is shown in

Figure 235

.

Figure 235 Row Statistics area layout

Row Statistics area fields:

•

Database Name—Name of the database.

•

Rows Queried/Sec—Number of rows affected by the select operation per second when APM last
polled DB2.

•

Rows Deleted/Sec—Number of rows affected by the delete operation per second when APM last
polled DB2.

•

Rows Inserted/Sec—Number of rows affected by the insert operation per second when APM last
polled DB2.

•

Rows Updated/Sec—Number of rows affected by the update operation per second when APM last
polled DB2.

Cache Performance

The Cache Performance area layout is shown in

Figure 236

.

Advertising