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