Neoview Workload Management Services Guide (R2.3)
3 DATALOADING
HOLD 0 0 0
1 SERVICE2
ACTIVE 1 0 0
2 SERVICE2
ACTIVE 1 0 0
3 SERVICE2
ACTIVE 0 0 0
1 SALESQUERIES
HOLD 0 0 0
2 SALESQUERIES
HOLD 0 0 0
3 SALESQUERIES
HOLD 0 0 0
1 SERVICE3
ACTIVE 1 0 0
2 SERVICE3
ACTIVE 0 0 0
3 SERVICE3
ACTIVE 1 0 0
1 HP_DEFAULT_SERVICE
ACTIVE 0 0 0
2 HP_DEFAULT_SERVICE
ACTIVE 0 0 0
3 HP_DEFAULT_SERVICE
ACTIVE 0 0 0
--- WMS operation complete.
NS%
For the syntax, see the “STATUS Command” (page 66).
Displaying the Status and Compile-Time Statistics of All Queries
Use the STATUS QUERIES ALL command to display the status of all queries being managed by
WMS. For example:
NS%status queries all;
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
MXID01002000687212075563079285896000000012114SUPER.SERVICES00_7794_SQL_CUR_3
COMPLETED HP_DEFAULT_SERVICE
0.03621300703690157 0.107988008066793
0.11072000134299742 0.11150500165967969 0.09800000134418951 0.03621300703690157
100.0 \WMS0102.$Z0DT CACNARAIN||COAST.exe
SUPER.SERVICES
262168 1 2008-04-03 18:17:48.675194 2008-04-03 18:17:48.675225
212075561868675225 212075561895388641
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
589848 1 2008-04-03 18:18:18.350083 2008-04-03 18:18:18.350125
212075561898350125 212075561898350133
MXID01002020452212075562925258497000000004204DBA100_244_S1
EXECUTING SERVICE1
2.1405113621293412 2.4270026755241196
Monitoring Services and Queries 43