Neoview Workload Management Services Guide (R2.3)

returns status information about the queries that are associated
with a role, such as ROLE.USER, or an alias of a role, such as dba1.
If you specify a role, the STATUS command returns only the queries
associated with the particular role and not the queries associated
with the aliases of the role.For more information, see Table A-8
(page 70).
role-name is the name of a user role, which can be a maximum
of 17 characters. The role name is case-sensitive.
alias-name is the name of an alias, which can be a maximum of
32 characters. The alias 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.
QUERIES ROLE {role-name |
alias-name} [state]
returns runtime statistics information about all the queries on the
system. For more information, see Table A-10 (page 71).
QUERY ALL STATS
returns status information about a query. query-id is the query
identifier and can be a maximum of 160 characters. For more
information, see Table A-8 (page 70).
QUERY query-id
returns runtime statistics of the specified query. query-id is the
query identifier and can be a maximum of 160 characters. For more
information, see Table A-10 (page 71).
QUERY query-id STATS
returns the query execution plan of the specified query. query-id
is the query identifier and can be a maximum of 160 characters.
PLAN must be enabled for the service in which the query is
running. For more information, see Table A-11 (page 73).
QUERY query-id PLAN
returns the SQL text of the specified query. query-id is the query
identifier and can be a maximum of 160 characters. TEXT must be
enabled for the service in which the query is running. For more
information, see Table A-11 (page 73).
QUERY query-id TEXT
Considerations
• The STATUS WMS option returns this status information:
Table A-3 System Status Information
DescriptionData TypeColumn Name
State of the system, which is INIT (for initialization), ACTIVE, HOLD,
SHUTDOWN, or STOP
VARCHAR(9)STATE
Maximum CPU busy allowed. If this value is zero, it means that WMS
uses the internal value of 100 percent.
INTMAX_CPU_BUSY
Maximum memory usage allowed. If this value is zero, it means that
WMS uses the internal value of 85 percent.
INTMAX_MEM_USAGE
Interval at which WMS collects query runtime statisticsINTSTATS_INTERVAL
Average disk I/O across the clusterFLOATDISK_IO
Average disk cache usage across the clusterFLOATDISK_CACHE
Average CPU busy across the clusterFLOATCPU_BUSY
Average memory usage across the clusterFLOATMEM_USAGE
• The STATUS WMS VERSION option returns this version information:
68 WMS Commands