HP Neoview Release 2.5 Software - Manual (Page 52)

Rule Warnings
Rule warnings display any warnings of Neoview WMS rule violations. The query’s WARN_LEVEL
(Warning Level) state is an indicator of rule warnings that were generated. The warning levels
currently supported and generated are Low, Medium, and High. This information is only available
for platforms enabled with Neoview WMS support for rules (that is, R2.4 and higher).
Per-Table Statistics
Per-table statistics display the runtime view of individual statistics for all tables involved in the
query. This document provides a short description about the columns in the Per-Table Statistics
table:
Description Metric
Name of the table. TableName
Compiler's estimated number of rows accessed. EstAccessedRows
Compiler's estimated number of rows returned after applying the
predicates. EstUsedRows
Actual number of rows accessed. AccessedRows
Number of rows returned after applying the predicates. In a push
down plan, all the used rows may not be returned. UsedRows
Count of the messages. MessageCount
Count of the message bytes sent to access the tables in this statement. MessageBytes
Number of disk reads for accessing the tables referenced in this
statement. DiskIOs
Displays the number of times this statement had to wait on a
conflicting lock. If this field is 0, no locks were encountered during
the processing of this statement. LockWaits
The number of times row locks escalated to a file lock during the
execution of this statement. If this field is 0, no locks were escalated
during this statement execution. LockEscalations
An approximation of the total CPU time spent for executing the
given query. ProcessBusyTime
Number of OPEN calls performed by the SQL executor on behalf of
this statement. Opens
Time this process spent doing OPENs on behalf of this statement. OpenTime
An internal counter indicating the last time (internal form) when
the per-table statistics were updated. LastUpdated
Get Query Text
Get Query Text provides the ability to retrieve the query text associated with the query being
monitored (watched). This tool contains a text box which “hosts” the query text, a control to turn
on/off the formatting of the query text and [Get Query Text]. [Get Query Text] retrieves the
query text from the repository.
At-A-Glance System Summary Information
The top pane of the Live View application contains a grid that shows a live listing of the queries
running on the Neoview platform. Just below this pane is a system summary information pane,
which provides an at-a-glance view of statement counters, services, and platform status counters.
52 Neoview Workload Management Services (WMS) Configuration