Neoview Workload Management Services Guide (R2.4)

MXID01002021092212106317746987210000000649109ROLE.USR200_19506_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212973907100 212110212974336408
212110213756193494 -1 FETCH 36975589 1407
1407 84 2464608 720 0
0 0 7648 4 7862 0
-1 0 11780 11552 16595 16429
178978 384 318 582 6 27981 1876.0
1876.0 8 106636 212110188631210751
MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212977919160 212110212978380261
212110213756192578 -1 FETCH 36977342 1407
1407 84 2464608 720 0
0 0 7846 4 7693 0
-1 0 11780 11552 16595 16429
182314 384 318 582 6 27981 1876.0
1876.0 8 105692 212110188631210751
MXID01002010657212109516853678165000000115709ROLE.USR100_3616_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212986756056 212110212987189967
212110213756192709 -1 FETCH 36978024 1407
1407 84 2464608 720 0
0 0 7420 4 6405 0
-1 0 11780 11552 16595 16429
179860 384 318 582 6 27981 1876.0
1876.0 8 100094 212110188631210751
MXID01003031050212108224567420861000000331309ROLE.USR100_9972_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212637399361 212110212637945264
212110213424353376 -1 FETCH 39078462 1407
1407 84 2464608 720 1
0 0 7969 4 5351 0
-1 0 11780 11552 16595 16429
177918 384 318 582 6 27981 1876.0
1876.0 8 58271 212110188600804034
MXID01003020793212110131970645532000000013409ROLE.USR100_435_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212640046381 212110212640604488
212110213424353158 -1 FETCH 39079596 1407
1407 84 2464608 720 0
0 0 7534 4 5879 0
-1 0 11780 11552 16595 16429
185693 384 318 582 6 27981 1876.0
1876.0 8 66648 212110188600804034
--- WMS operation complete.
NS%
For the syntax, see the “STATUS QUERIES Command” (page 127).
Use the STATUS QUERY query-id STATS command to display the runtime statistics of an
executing query being managed by WMS. For example, this STATUS QUERY query-id STATS
command displays the runtime statistics of a specific executing query being managed by WMS:
NS%status query MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1 stats;
QUERY_ID
QUERY_STATE QUERY_SUBSTATE 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 TOTAL_MEM_ALLOC EST_ACCESSED_ROWS EST_USED_ROWS
PROCESSES_CREATED PROCESS_CREATE_TIME LAST_UPDATED
----------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------- -------------------- -------------------- -------------------- --------------------
--------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------------- --------------------
-------------------- -------------------- -------------------- -------------- -------------------- ----------------
--------------- -------------- -------------- ------------- -------------------- --------------- --------------
-------------- ------------- --------------- ------------------------ ------------------------
-------------------- -------------------- --------------------
MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1
EXECUTING S1
SELECT_NON_UNIQUE 212110212966002221 212110212966613506
212110213756193351 -1 FETCH 112126014 1407
1407 84 2464608 720 0
0 0 8336 4 4607 0
-1 0 11780 11552 16595 16429
Monitoring Queries 73