HP Neoview Release 2.5 Software - Manual (Page 95)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Estimate of the number of seconds of
processor time it might take to execute the
query. The estimate occurs at the time the
query is prepared.
NOTE: For future use. Currently zero (0).
INTEGER DEFAULT
NULL EST_RESOURCE_USAGE
Status of the query. One of these:
INIT
COMPLETED
REJECTED
CANCELLED
CHAR(21) DEFAULT
NULL QUERY_STATUS
Substatus of the query, dependent on
QUERY_STATUS
When QUERY_STATUS = COMPLETED or
CANCELLED, possible values for
QUERY_SUB_STATUS are:
• HOLD_TIMEOUT
• EXEC_TIMEOUT
• CANCELLED_BY_ADMIN
• QUERY_NOT_FOUND
• NDCS_PROCESS_FAILED
• CPU_FAILED
• SEGMENT_FAILED
• BY_EXEC_RULE
• SERVICE_NOT_ACTIVE
• UNEXPECTED_STATE
• CLIENT_DISAPPEARED
• CONNECTION_FAILED
When QUERY_STATUS = REJECTED,
possible values for QUERY_SUB_STATUS
are:
• BY_ADMIN
• CONNECTION_FAILED
• HOLD_TIMEOUT
• WAIT_TIMEOUT
• NDCS_PROCESS_FAILED
• CPU_FAILED
• SEGMENT_FAILED
• QUEUE_MSG_CANCELLED
• VERSION_MISMATCH
• WMS_ON_HOLD
• MAX_QUERIES_REACHED
• SERVICE_NOT_FOUND
• SERVICE_ON_HOLD
• BY_COMP_RULE
• UNKNOWN_USER
• CLIENT_DISAPPEARED
• UNEXPECTED_STATE
For more information, refer to the Neoview
Workload Management Services Guide.
CHAR(30) DEFAULT
NULL QUERY_SUB_STATUS
Query Statistics for R2.4 SP2 95