Manualshelf

Neoview Workload Management Services Guide (R2.3)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software
41424344454647484950
Displaying Runtime Statistics of All Queries
Use the STATUS QUERIES ALL STATS or STATUS QUERY ALL STATS command to display
the runtime statistics of all queries being managed by WMS.
NOTE: By default, WMS collects runtime statistics for all executing queries at an interval of
five seconds.
For example, this STATUS QUERIES ALL STATS command displays the runtime statistics of all
queries being managed by WMS:
NS%status queries all stats;
QUERY_ID
QUERY_STATE STATEMENT_ID
STATEMENT_TYPE COMP_START_TIME COMP_END_TIME EXEC_START_TIME EXEC_END_TIME
EXEC_STATE ELAPSED_TIME ACCESSED_ROWS USED_ROWS MESSAGE_COUNT
MESSAGE_BYTES STATS_BYTES DISK_IOS LOCK_WAITS LOCK_ESCALATIONS
PROCESS_BUSYTIME OPENS OPEN_TIME SQL_ERROR_CODE NUM_ROWS_IUD STATS_ERROR_CODE
SQL_SPACE_ALLOC SQL_SPACE_USED SQL_HEAP_ALLOC SQL_HEAP_USED SQL_CPU_TIME EID_SPACE_ALLOC EID_SPACE_USED
EID_HEAP_ALLOC EID_HEAP_USED EST_ACCESSED_ROWS EST_USED_ROWS PROCESSES_CREATED
PROCESS_CREATE_TIME LAST_UPDATED
----------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------- -------------------- -------------------- -------------------- --------------------
--------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------- -------------------- ----------------
--------------- -------------- -------------- ------------- -------------------- --------------- --------------
-------------- ------------- ------------------------ ------------------------ --------------------
-------------------- --------------------
MXID01001010517212075562920126981000000004004DBA100_238_S1
EXECUTING
SELECT_NON_UNIQUE 0 0 0 -1
INITIAL -1 0 0 0
0 0 0 0 0
0 0 0 -8921 0 0
0 0 0 0 0 0 0
0 0 0.0 0.0 0
0 212075561898449906
MXID01002000687212075563079285896000000012114SUPER.SERVICES00_7794_SQL_CUR_3
COMPLETED
SELECT_NON_UNIQUE 212075587066424882 212075587068654585 212075587068676346 212075587069616089
DEALLOCATED 939743 1 1 2
12048 344 0 0 0
259 1 374 0 -1 0
96 65 7 5 78 64 55
97 1 100.0 100.0 0
0 212075561895388651
MXID01003020448212075562925137594000000004204DBA100_244_S1
EXECUTING
SELECT_NON_UNIQUE 0 0 0 -1
INITIAL -1 0 0 0
0 0 0 0 0
0 0 0 -8921 0 0
0 0 0 0 0 0 0
0 0 0.0 0.0 0
0 212075561897764939
MXID01001021072212075562925165799000000004104DBA100_239_S1
EXECUTING
SELECT_NON_UNIQUE 0 0 0 -1
INITIAL -1 0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0.0 0.0 0
0 212075561898449906
MXID01002020452212075562925258497000000004204DBA100_244_S1
EXECUTING
SELECT_NON_UNIQUE 0 0 0 -1
INITIAL -1 0 0 0
0 0 0 0 0
0 0 0 -8921 0 0
0 0 0 0 0 0 0
0 0 0.0 0.0 0
0 212075561895388651
MXID01003010491212075562925097818000000004004DBA100_234_S1
EXECUTING
SELECT_NON_UNIQUE 0 0 0 -1
48 Managing Workload in WMS