Neoview Workload Management Services Guide (R2.4)

Table A-13 Query Runtime Statistics
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
State of the query, which is WAITING, EXECUTING,
HOLDING, REJECTED or COMPLETED
VARCHAR(9)QUERY_STATE
When QUERY_STATE = WAITING:
— MAX_CPU_BUSY
— MAX_MEM_USAGE
— RELEASED_BY_ADMIN
When QUERY_STATE = EXECUTING:
— RELEASED_BY_ADMIN
When QUERY_STATE = HOLDING:
— LOADING
— PREPARING
— EXECUTING_SQL_CMD
— BY_COMP_RULE
— BY_ADMIN
— SUSPENDED_BY_ADMIN
When QUERY_STATE = COMPLETED:
— 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
When QUERY_STATE = REJECTED:
— BY_ADMIN
— CONNECTION_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
— UNEXPECTED_STATE
— CLIENT_DISAPPEARED
VARCHAR(30)QUERY_SUBSTATE
Statement identifier specified by the client applicationVARCHAR(160)STATEMENT_ID
132 WMS Commands