Neoview Workload Management Services Guide (R2.4)

STATUS QUERY Command
The STATUS QUERY command returns information about the specified query that is currently
being managed by WMS.
Syntax
STATUS QUERY { ALL STATS | query-id [ { STATS | PLAN | TEXT } ] }
ALL STATS
returns runtime statistics information about all the queries in WMS. For output information,
see Table A-13 (page 132).
query-id
returns status information about a query. query-id is the query identifier and can be a
maximum of 160 characters. For output information, see Table A-11 (page 128).
query-id STATS
returns runtime statistics of the specified query. query-id is the query identifier and can
be a maximum of 160 characters. For output information, see Table A-13 (page 132).
query-id PLAN
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 output information, see Table A-15 (page 136).
query-id TEXT
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 output information, see Table A-16 (page 136).
Considerations
• The STATUS QUERY command without the STATS, PLAN, or TEXT option returns query
status information. See Table A-11 (page 128).
• The STATUS QUERY command with STATS or ALL STATS returns query runtime statistics.
See Table A-13 (page 132).
• The STATUS QUERY command with PLAN returns the query execution plan:
Table A-15 STATUS QUERY With PLAN Output
DescriptionData TypeColumn Name
Text for the query execution plan, which is returned in ISO8859-1
encoding. To interpret query execution plans, see the Neoview
Query Guide.
VARCHAR(3900)QUERY_PLAN
• The STATUS QUERY command with TEXT returns the SQL syntax for the query:
Table A-16 STATUS QUERY With TEXT Output
DescriptionData TypeColumn Name
Text for the SQL query syntax, which is returned in UTF8
encoding.
VARCHAR(3900)QUERY_TEXT
Examples
• This command displays runtime statistics information about all the queries in WMS:
STATUS QUERY ALL STATS;
• This command displays status information of the specified query:
136 WMS Commands