Manualshelf

Neoview Workload Management Services Guide (R2.3)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software
41424344454647484950
• Use the STATUS QUERIES <state> command to filter query status results according to the
query state (for example, waiting, executing, or holding).
• Use the STATUS QUERIES SERVICE <service> <state> command to filter query status results
according to the service and optionally the query state (for example, waiting, executing, or
holding).
• Use the STATUS QUERIES ROLE <name> <state> command to filter query status results
according to the client role or alias, and optionally the query state (for example, waiting,
executing, or holding).
• Use the STATUS QUERY <query-id> command to filter query status results according to
the query ID.
For example, this STATUS QUERIES <state> command displays status information about queries
in the executing state:
NS%status queries 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
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 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
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 212075561895388641
MXID01003010491212075562925097818000000004004DBA100_234_S1
EXECUTING SERVICE3
2.1405113621293412 2.4270026755241196
0.43943207564842224 0.45029863646618223 0.39207400850312774 2.1405113621293412
1.0 \WMS0103.$Z0FH PC-D530||FASTJDBC
DBA1
589848 1 2008-04-03 18:18:15.981358 2008-04-03 18:18:15.981392
212075561895981392 212075561895981400
--- WMS operation complete.
NS%
Monitoring Services and Queries 45