Neoview Workload Management Services Guide (R2.5)

This command displays the runtime statistics of the specified query:
STATUS QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1 STATS;
This command displays the query execution plan of the specified query:
STATUS QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1 PLAN;
This command displays the SQL text of the specified query:
STATUS QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1 TEXT;
STATUS QUERY Command 239