Neoview Workload Management Services Guide (R2.4)

Table A-14 Aggregated Statistics of Executing Queries (continued)
DescriptionData TypeColumn Name
Number of executing queries in the open state for this segmentINTTOT_OPEN
Number of executing queries in the end-of-file state for this segmentINTTOT_EOF
Number of executing queries in the close state for this segmentINTTOT_CLOSE
Number of executing queries in the deallocate state for this segmentINTTOT_DEALLOCATED
Number of executing queries in the fetch state for this segmentINTTOT_FETCH
Number of executing queries in the close_tables state for this segmentINTTOT_CLOSE_TABLES
Number of executing queries in the prepare state for this segmentINTTOT_PREPARE
Examples
• This command displays information for all the queries in WMS:
STATUS QUERIES ALL;
• This command displays runtime statistics information about all the queries in WMS:
STATUS QUERIES ALL STATS;
• This command displays status information for all the waiting queries in WMS:
STATUS QUERIES WAITING;
• This command displays the total number of executing queries in various states in WMS:
STATUS QUERIES EXECUTING STATS;
• This command displays information for all queries in SERVICE1:
STATUS QUERIES SERVICE SERVICE1;
• This command displays information for the executing queries in SERVICE1:
STATUS QUERIES SERVICE SERVICE1 EXECUTING;
• This command displays information for all the queries that belong to the role, role.mgr:
STATUS QUERIES ROLE role.mgr;
• This command displays information for the holding queries that belong to the role, role.mgr:
STATUS QUERIES ROLE role.mgr HOLDING;
STATUS QUERIES Command 135