Neoview Workload Management Services Guide (R2.4)
SQL>mode ns
NS%status query MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1 text;
QUERY_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from
neo.sales.customers a
, neo.sales.orders b
, neo.sales.odetail c
, neo.sales.parts d
--- WMS operation complete.
NS%
For the syntax, see the “STATUS QUERY Command” (page 136).
Displaying Warning Information
Use these STATUS QUERIES commands to display warning information for queries running in
WMS:
• Use the STATUS QUERIES WARN command to display warning information for queries
at all warning levels:
STATUS QUERIES WARN;
• Use the STATUS QUERIES WARN-LOW command to display warning information for
queries at the low warning level:
STATUS QUERIES WARN-LOW;
• Use the STATUS QUERIES WARN-MEDIUM command to display warning information
for queries at the medium warning level:
STATUS QUERIES WARN-MEDIUM;
• Use the STATUS QUERIES WARN-HIGH command to display warning information for
queries at the high warning level:
STATUS QUERIES WARN-HIGH;
Each of the commands listed above displays the same columns of data in its output. For more
information, see Table A-12 (page 131).
For example, this STATUS QUERIES WARN command shows that a compilation rule,
COMPRULE3, triggered a low warning because the estimated used rows for the queries exceeded
1000 and that an execution rule, EXECRULE2, triggered a medium warning because the actual
used rows for queries executing longer than five minutes was equal to or greater than 1000:
SQL>mode ns
NS%status queries warn;
QUERY_ID
SERVICE_NAME
WARN_TYPE WARN_LEVEL RULE_NAME
EXPR REASON
----------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------ ---------
---------- ------------------------------------------------------------------------------------------------
-----------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1
SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01002021092212106317746987210000000649109ROLE.USR200_19506_S1
SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1
SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01002010657212109516853678165000000115709ROLE.USR100_3616_S1
Displaying Warning Information 75