Neoview Workload Management Services Guide (R2.5)

C Query States and Substates
This table describes the states and substates that a query might have at different times while
being managed by WMS.
Table C-1 Query States and Substates
DescriptionSubstateQuery State
The query has been put in the waiting queue
because the CPU busy exceeds the
MAX_CPU_BUSY value.
WMS_MAX_CPU_BUSYWAITING
The query has been put in the waiting queue
because the memory usage exceeds the
MAX_MEM_USAGE value.
WMS_MAX_MEM_USAGE
The query has been put in the waiting queue after
being released from the holding state by an
administrator.
WMS_QUERY_RELEASED_BY_ADMIN
The query is executing after being released from
the holding state by an administrator.
WMS_QUERY_RELEASED_BY_ADMINEXECUTING
The query is still executing while its cancellation
is in progress.
CANCEL_IN_PROGRESS
A LOAD QUERY command is loading the query
execution plan and/or SQL text of the holding
query into shared memory.
WMS_QUERY_LOADINGHOLDING
A REPREPARE QUERY command is repreparing
the holding query.
WMS_QUERY_REPREPARING
The query was put on hold by a compilation rule
because certain conditions were met.
WMS_COMP_RULE
The query was put on hold by an administrator
who issued a HOLD command.
WMS_ADMIN
The executing query is suspended by an
administrator who issued a HOLD
QUERY/QUERIES command.
WMS_ADMINSUSPENDED
The suspended query is cancelled by an
administrator who issued a CANCEL command.
WMS_QUERY_CANCELED_BY_ADMIN
The suspended query is cancelled by an execution
timeout value.
WMS_QUERY_CANCELED_BY_TIMEOUT
The waiting or holding query is rejected before
executing by an administrator who issued a
CANCEL command.
WMS_ADMINREJECTED
The waiting or holding query is rejected before
executing because a connection failed between the
client and server.
WMS_CONNECTION_FAILED
The waiting or holding query is rejected before
executing because the NDCS server process failed.
NDCS_PROCESS_FAILED
The waiting or holding query is rejected before
executing because a CPU failed.
WMS_CPU_FAILED
The waiting or holding query is rejected before
executing because the NDCS version does not
match the WMS version.
WMS_VERSION_MISMATCH
263