Neoview Workload Management Services Guide (R2.3)

• This command displays status information for the SALESQUERIES service:
STATUS SERVICE salesqueries
• This command displays statistics for all the services on the system:
STATUS SERVICE STATS
• This command displays status information for all the queries on the system:
STATUS QUERIES ALL
• This command displays runtime statistics information about all the queries on the system:
STATUS QUERIES ALL STATS
• This command displays status information for all the waiting queries on the system:
STATUS QUERIES WAITING
• This command displays the total number of executing queries in various states on the system:
STATUS QUERIES EXECUTING STATS
• This command displays status information for all queries in the DATALOADING service:
STATUS QUERIES SERVICE dataloading
• This command displays status information for the executing queries in the DATALOADING
service:
STATUS QUERIES SERVICE dataloading EXECUTING
• This command displays status information for all the queries that belong to the role, role.mgr:
STATUS QUERIES ROLE role.mgr
• This command displays status information for the holding queries that belong to the role,
role.mgr:
STATUS QUERIES ROLE role.mgr HOLDING
• This command displays runtime statistics information about all the queries on the system:
STATUS QUERY ALL STATS
• This command displays status information of the specified query:
STATUS QUERY MXID0100100050121203677536...
• This command displays the runtime statistics of the specified query:
STATUS QUERY MXID0100100050121203677536... STATS
• This command displays the query execution plan of the specified query:
STATUS QUERY MXID0100100050121203677536... PLAN
• This command displays the SQL text of the specified query:
STATUS QUERY MXID0100100050121203677536... TEXT
74 WMS Commands