Neoview Workload Management Services Guide (R2.3)
For example, this STATUS QUERIES SERVICE command displays status information about
queries in the SERVICE2 service that are in the executing state:
NS%status queries service service2 executing;
QUERY_ID
QUERY_STATE SERVICE_NAME
EST_COST EST_CPU_TIME EST_IO_TIME
EST_MSG_TIME EST_IDLE_TIME EST_TOTAL_TIME EST_CARDINALITY
PROCESS_NAME QUERY_NAME
ROLE_NAME
SERVICE_INDEX QUERY_INDEX START_TS ENTRY_TS
ENTRY_JTS LAST_UPDATED
----------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ------------------------------------------------------------------------------------------------
------------------------ ------------------------ ------------------------ ------------------------
------------------------ ------------------------ ------------------------ --------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------- ------------- ----------- --------------------------
-------------------------- -------------------- --------------------
MXID01001010517212075562920126981000000004004DBA100_238_S1
EXECUTING SERVICE2
2.1405125845796156 2.4270030100716777
0.43943207564842224 0.4502995243688986 0.39207400850312774 2.1405125845796156
1.0 \WMS0101.$Z12K PC-D530||FASTJDBC
DBA1
524312 0 2008-04-03 18:18:13.372013 2008-04-03 18:18:13.372035
212075561893372035 212075561898350133
MXID01002010476212075562920218543000000004004DBA100_234_S1
EXECUTING SERVICE2
2.1405113621293412 2.4270026755241196
0.43943207564842224 0.45029863646618223 0.39207400850312774 2.1405113621293412
1.0 \WMS0102.$Z0DN PC-D530||FASTJDBC
DBA1
524312 3 2008-04-03 18:18:15.388603 2008-04-03 18:18:15.388633
212075561895388633 212075563928780174
--- WMS operation complete.
NS%
For example, this STATUS QUERIES ROLE command displays status information about queries
associated with the client alias, DBA1:
NS%status queries role dba1;
QUERY_ID
QUERY_STATE SERVICE_NAME
EST_COST EST_CPU_TIME EST_IO_TIME
EST_MSG_TIME EST_IDLE_TIME EST_TOTAL_TIME EST_CARDINALITY
PROCESS_NAME QUERY_NAME
ROLE_NAME
SERVICE_INDEX QUERY_INDEX START_TS ENTRY_TS
ENTRY_JTS LAST_UPDATED
----------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ------------------------------------------------------------------------------------------------
------------------------ ------------------------ ------------------------ ------------------------
------------------------ ------------------------ ------------------------ --------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------- ------------- ----------- --------------------------
-------------------------- -------------------- --------------------
MXID01001010517212075562920126981000000004004DBA100_238_S1
EXECUTING SERVICE2
2.1405125845796156 2.4270030100716777
0.43943207564842224 0.4502995243688986 0.39207400850312774 2.1405125845796156
1.0 \WMS0101.$Z12K PC-D530||FASTJDBC
DBA1
524312 0 2008-04-03 18:18:13.372013 2008-04-03 18:18:13.372035
212075561893372035 212075561898350133
MXID01002020452212075562925258497000000004204DBA100_244_S1
EXECUTING SERVICE1
2.1405113621293412 2.4270026755241196
0.43943207564842224 0.45029863646618223 0.39207400850312774 2.1405113621293412
1.0 \WMS0102.$Z0DR PC-D530||FASTJDBC
DBA1
458776 0 2008-04-03 18:18:09.613894 2008-04-03 18:18:09.613916
212075561889613916 212075563928780174
MXID01003020448212075562925137594000000004204DBA100_244_S1
EXECUTING SERVICE1
2.1405113621293412 2.4270026755241196
0.43943207564842224 0.45029863646618223 0.39207400850312774 2.1405113621293412
1.0 \WMS0103.$Z0FJ PC-D530||FASTJDBC
DBA1
458776 0 2008-04-03 18:18:11.032345 2008-04-03 18:18:11.032383
212075561891032383 212075561895981400
MXID01001021072212075562925165799000000004104DBA100_239_S1
EXECUTING SERVICE3
2.1405113621293412 2.4270026755241196
0.43943207564842224 0.45029863646618223 0.39207400850312774 2.1405113621293412
1.0 \WMS0101.$Z12N PC-D530||FASTJDBC
DBA1
46 Managing Workload in WMS