HP Neoview Release 2.5 Software User Manual
Page 51
Description
Metric
ID of the parent query. If there is no parent query ID associated with
the query, NONE is displayed.
Parent Query ID
Process priority of the master executor process.
Query Priority
ID of the transaction under which the query is executed. When there
is no transaction, the transaction ID is -1.
Transaction ID
Number of rows returned from the root operator of the master
executor process.
Rows Returned
Timestamp at which the first row is returned from the root operator
of the master executor process.
First Row Returned Time
Number of messages initiated from the master to ESPs or from an
ESP to ESPs.
Req Message Count
Number of message bytes that are sent from the master to ESPs or
from an ESP to ESPs as part of the request messages.
Req Message Bytes
Number of reply messages from the ESPs for the message requests.
Reply Message Count
Number of bytes sent as part of the reply messages.
Reply Message Bytes
Error code that triggered the Automatic Query Retry (AQR) for the
recent retry.
Last Error Before Aqr
Number of retries that occurred for this query until now.
Aqr Num Retries
Number of seconds that the SQL engine waited before it initiated an
AQR.
Delay Before Aqr
Maximum memory used by the query.
Max Memory Used
Number of SQL processes (excluding ESAM processes) involved in
executing the query.
Num SQL Processes
Text of the SQL query.
Query Text
Length of the query text.
Query Text Len
Time (in Julian time) when the execution statistics were last updated.
Exec Last Updated
Either YES or NO, indicating whether this query's statistics are
aggregated.
Aggr Query
Total number of queries in theaggregated query.
Aggr Total Queries
Difference in seconds between the current time and the last time that
aggregation was updated.
Aggr Secs Since Last Update
Difference in seconds between the current time and the first time that
aggregation was updated.
Aggr Secs Total Time
Displayed as rule-name:expr-num, where rule-name is the last
connection rule evaluated for the query and expr-num is the total
number of rule expressions.
Conn Rule Name
Displayed as rule-name:expr-num, where rule-name is the last
compilation rule evaluated for the query and expr-num is either the
ordinal position of the expression that evaluated to true or ALL for
all expressions evaluating to true.
Comp Rule Name
Displayed as rule-name:expr-num, where rule-name is the last
execution rule evaluated for the query and expr-num is either the
ordinal position of the expression that evaluated to true or ALL for
all expressions evaluating to true.
Exec Rule Name
Configuring Neoview WMS Services and Rules With Live View
51