Neoview Workload Management Services Guide (R2.5)

STATUS QUERIES Command
The STATUS QUERIES command returns information about the queries currently being managed
by WMS.
Syntax
STATUS QUERIES [option]
option is:
[ ALL [ STATS ] ]
| [ EXECUTING STATS ]
| [ query-state ]
| [ warn-level ]
| [ SERVICE service-name [ query-state ] ]
| [ ROLE name [ query-state ] ]
query-state is:
{ EXECUTING | WAITING | HOLDING }
warn-level is:
{ WARN | WARN-LOW | WARN-MEDIUM | WARN-HIGH }
ALL
returns status information about all the queries in WMS. For output information, see
Table A-12 (page 230).
ALL STATS
returns runtime statistics information for all the queries in WMS. For output information,
see Table A-14 (page 233).
EXECUTING STATS
returns the total number of executing queries in various states in WMS. For output information,
see Table A-15 (page 236).
query-state
returns warning information for all the queries in the specified state. query-state is one
of these query states:
• EXECUTING
• WAITING
• HOLDING
For output information, see Table A-12 (page 230).
warn-level
returns status information about all the queries at the specified warning level. warn-level
is one of these warning states:
• WARN (all warning levels)
• WARN-LOW
• WARN-MEDIUM
• WARN-HIGH
For output information, see Table A-13 (page 232).
SERVICE service-name [ query-state ]
returns status information about the queries that are associated with a service. For output
information, see Table A-12 (page 230).
service-name is the name of a user-defined service for managing queries. service-name
can be a maximum of 24 characters and must be a unique name in WMS. service-name
must exist in the WMS configuration but cannot be the SYSTEM service. The service name
is not case-sensitive and is always converted to uppercase. WMS supports multibyte characters
STATUS QUERIES Command 229