Neoview Workload Management Services Guide (R2.4)

Table A-11 Query Compile-Time Statistics (continued)
DescriptionData TypeColumn Name
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
VARCHAR(30)QUERY_SUBSTATE
Name of the serviceVARCHAR(96)SERVICE_NAME
Estimated cost associated with executing
the query
DOUBLE
PRECISION
EST_COST
Estimated number of seconds of processor
time it might take to execute the instructions
of the query execution plan. A value of 1.0
is 1 second.
DOUBLE
PRECISION
EST_CPU_TIME
Estimated number of seconds of I/O time
(seeks plus data transfer) to perform the I/O
for this query
DOUBLE
PRECISION
EST_IO_TIME
STATUS QUERIES Command 129