Neoview Workload Management Services Guide (R2.3)

Syntax
STATUS type
type is:
{ WMS [VERSION] }
| { SERVICE [ ALL | service-name | STATS ] }
| { QUERIES [ ALL [ STATS ]
| EXECUTING [STATS]
| WAITING
| HOLDING ] }
| { QUERIES SERVICE service-name [EXECUTING | WAITING | HOLDING] }
| { QUERIES ROLE {role-name | alias-name} [EXECUTING | WAITING | HOLDING] }
| { QUERY ALL STATS
| query-id [STATS | PLAN | TEXT] }
type
specifies one of these items for which to return status information:
returns status information about WMS and system resources. For
more information, see Table A-3 (page 68).
WMS
returns version information for the internal WMS processes. For
more information, see Table A-4 (page 69) and Table A-5 (page 69).
WMS VERSION
returns status information about all the services on the system. For
more information, see Table A-6 (page 69).
SERVICE ALL
returns status information about the specified service.
service-name is the name of a user-defined service for managing
queries. The service name is not case-sensitive and is always
converted to uppercase. WMS supports multibyte characters in the
service name. For guidelines on using multibyte character sets, see
the Neoview Character Sets Administrator's Guide.For more
information, see Table A-6 (page 69)
SERVICE service-name
returns statistics for all the services on the system. For more
information, see Table A-7 (page 69).
SERVICE STATS
returns status information about all the queries on the system. For
more information, see Table A-8 (page 70).
QUERIES ALL
returns runtime statistics information about all the queries on the
system. For more information, see Table A-10 (page 71).
QUERIES ALL STATS
returns status information about all the queries in the specified
state. state is one of these query states:
• EXECUTING
• WAITING
• HOLDING
For more information, see Table A-8 (page 70).
QUERIES state
returns the total number of executing queries in various states on
the system. For more information, see Table A-9 (page 71).
QUERIES EXECUTING STATS
returns status information about the queries that are associated
with a service. For more information, see Table A-8 (page 70).
service-name is the name of a user-defined service for managing
queries. The service name is not case-sensitive and is always
converted to uppercase. WMS supports multibyte characters 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.
QUERIES SERVICE service-name
[state]
STATUS Command 67