Neoview Workload Management Services Guide (R2.5)

Table A-12 Query Compile-Time Statistics (continued)
DescriptionData TypeColumn Name
Application ID and computer name delimited by the ||
character
VARCHAR(200)QUERY_NAME
The client role nameVARCHAR(50)ROLE_NAME
LOW, MEDIUM, HIGH, or blank when no warnings exist
for the query. If more than one warning level exists for the
query, the highest warning level appears here.
VARCHAR(6)WARN_LEVEL
Local civil time when the query was registered in WMS.
YYYY-DD-MM HH:MM:SS.aaabbb (aaa=milliseconds,
bbb=microseconds)
VARCHAR(26)START_TS
Local civil time when the query was inserted into the
service. YYYY-DD-MM HH:MM:SS.aaabbb
(aaa=milliseconds, bbb=microseconds)
VARCHAR(26)ENTRY_TS
Unformatted local civil time when the query was inserted
into the service. YYYY-DD-MM HH:MM:SS.aaabbb
(aaa=milliseconds, bbb=microseconds)
LARGEINTENTRY_JTS
Local civil time when the shared memory block was last
updated
LARGEINTLAST_UPDATED
Either YES or NO, indicating whether the query's statistics
are aggregated. For more information, see “Query Statistics
Aggregation” (page 27).
VARCHAR(3)AGGR_QUERY
Total number of queries in the aggregated queryLARGEINTAGGR_TOTAL_QUERIES
Difference in seconds between the current time and the
last time that the aggregation was updated
LARGEINTAGGR_SECS_SINCE_LAST_UPDATE
Difference in seconds between the current time and the
first time that aggregation was updated
LARGEINTAGGR_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
VARCHAR(100)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
VARCHAR(100)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
VARCHAR(100)EXEC_RULE_NAME
Query Warning Information
The STATUS QUERIES WARN command returns this warning information for queries:
Table A-13 Query Warning Information
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
Name of the WMS serviceVARCHAR(96)SERVICE_NAME
CONN for a connection rule
COMP for a compilation rule
EXEC for an execution rule
VARCHAR(4)WARN_TYPE
232 WMS Commands