
Table 3-1 QUERY_STATS_VW2 Field Definitions (continued)
DescriptionData TypeField Name
Connection rule.CHAR(84) DEFAULT
NULL
CONN_RULE
Compilation rule.CHAR(84) DEFAULT
NULL
COMP_RULE
Execution rule.CHAR(84) DEFAULT
NULL
EXEC_RULE
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
26 Repository Views
Komentáře k této Příručce