Neoview Workload Management Services Guide (R2.5)

in the service name. For guidelines on using multibyte character sets, see the Neoview Character
Sets Administrator's Guide.
query-state is one of these query states:
• EXECUTING
• WAITING
• HOLDING
If you do not specify a query state, the command returns status information for all queries
associated with the service.
ROLE name [ query-state ]
returns status information about the queries that are associated with a Neoview role or user
name. If you specify a role, the STATUS command returns the queries associated with the
role. If you specify a user name, the STATUS command returns the queries associated with
the user name. For output information, see Table A-12 (page 230).
name is the name of a role, such as ROLE.MGR, or a user name, such as USERMGR. name
can be a maximum of 17 characters and is case-sensitive.
query-state is one of these query states:
• EXECUTING
• WAITING
• HOLDING
If you do not specify a query state, the command returns status information for all queries
associated with the role or alias.
Considerations
Query Compile-Time Statistics
The STATUS QUERIES command without the ALL STATS option return this status information:
Table A-12 Query Compile-Time Statistics
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
State of the query:
• WAITING
• EXECUTING
• HOLDING
• SUSPENDED
• REJECTED
• COMPLETED
For more information, see Appendix C (page 263).
VARCHAR(9)QUERY_STATE
Substate of the query. For more information, see
Appendix C (page 263).
VARCHAR(30)QUERY_SUBSTATE
Name of the serviceVARCHAR(96)SERVICE_NAME
Estimated cost associated with executing the queryDOUBLE
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
230 WMS Commands