Manualshelf

Neoview Workload Management Services Guide (R2.3)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software
41424344454647484950
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 212075561897764939
MXID01002000687212075563079285896000000012114SUPER.SERVICES00_7802_SQL_CUR_3
COMPLETED
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 212075561895388651
MXID01002010476212075562920218543000000004004DBA100_234_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 212075561895388651
--- WMS operation complete.
NS%
For the syntax, see the “STATUS Command” (page 66).
Displaying Runtime Statistics of a Specific Query
Use the STATUS QUERY <query-id> STATS command to display the runtime statistics of a query
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 QUERY <query-id> STATS command displays the runtime statistics
of a specific query being managed by WMS:
NS%status query MXID01002010476212075562920218543000000004004DBA100_234_S1 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
----------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------- -------------------- -------------------- -------------------- --------------------
--------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------- -------------------- ----------------
--------------- -------------- -------------- ------------- -------------------- --------------- --------------
-------------- ------------- ------------------------ ------------------------ --------------------
-------------------- --------------------
MXID01002010476212075562920218543000000004004DBA100_234_S1
EXECUTING
SELECT_NON_UNIQUE 212075587094687749 212075587095358574 212075587095389714 -1
OPEN 64941004 0 0 0
0 0 0 0 0
0 0 0 0 -1 0
105 86 15 9 603 0 0
0 0 624.0 624.0 8
25498 212075561960330724
--- WMS operation complete.
NS%
For the syntax, see the “STATUS Command” (page 66).
Monitoring Services and Queries 49