Neoview Workload Management Services Guide (R2.4)

in the service name. For guidelines on using multibyte character sets, see the Neoview Character
Sets Administrator's Guide.
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 role or user name (the
alias of a role). If you specify a role, the STATUS command returns the queries associated
with the role and with the aliases of the role. If you specify an alias, the STATUS command
returns only the queries associated with the particular alias and not with the role. For output
information, see Table A-11 (page 128).
name is the name of a user role, such as ROLE.USER, or an alias, such as roleuser. name can
be a maximum of 17 characters and is case-sensitive.
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
• The STATUS QUERIES command without the ALL STATS option return this status
information:
Table A-11 Query Compile-Time 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
128 WMS Commands