Neoview Workload Management Services Guide (R2.5)

DescriptionName
Internal name of the query containing the client host name concatenated with the
application name
Query Name
Name of the user connected to the Neoview platformUser Name
Name of the data source for the connectionDatasource
Identifier 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 processQuery Priority
Identifier of the transaction under which the query is executedTransaction Id
Number of rows returned from the root operator of the master executor processRows Returned
Timestamp when the first row was 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 ESPsReq 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 requestsReply Message Count
Number of bytes sent as part of the reply messagesReply Message Bytes
Error code that triggered the Automatic Query Retry (AQR) for the recent retryLast Error Before Aqr
Number of retries that occurred for this query until nowAqr Num Retries
Number of seconds that the SQL engine waited before it initiated an AQRDelay Before Aqr
Maximum memory used by the query, which is the sum of the SQL Space Alloc, SQL
Heap Alloc, EID Space Alloc, and EID Heap Alloc
Max Memory Used
Number of SQL processes (excluding ESAM processes) involved in executing the
query
Num Sql Processes
SQL text of the queryQuery Text
Length of the query text, including spacesQuery Text Len
Time (in Julian format) when the execution (runtime) statistics were last updatedExec Last Updated
Either YES or NO, indicating whether the query's statistics are aggregatedAggr Query
Total number of queries in the aggregated queryAggr 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
132 Monitoring and Managing Workloads