beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 51

background image

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