Neoview Workload Management Services Guide (R2.3)

Table A-7 Statistics for All Services on the System (continued)
DescriptionData TypeColumn Name
Number of waiting queries for the service across the clusterINTWAITING
Number of holding queries for the service across the clusterINTHOLDING
• The STATUS QUERIES and STATUS QUERY without the STATS, PLAN, or TEXT option
return this status information:
Table A-8 Query Status Information
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
State of the query, which is INIT, WAITING, EXECUTING, or
HOLDING
VARCHAR(9)QUERY_STATE
Name of the serviceVARCHAR(96)SERVICE_NAME
Estimated cost associated with executing the queryDOUBLE PRECISIONEST_COST
Estimated number of seconds of processor time it might take to
execute the instructions of the query execution plan. A value of
1.0 is 1 second.
DOUBLE PRECISIONEST_CPU_TIME
Estimated number of seconds of I/O time (seeks plus data transfer)
to perform the I/O for this query
DOUBLE PRECISIONEST_IO_TIME
Estimated number of seconds it takes for the messaging for the
query. The estimate includes the time for the number of local and
remote messages and the amount of data sent.
DOUBLE PRECISIONEST_MSG_TIME
Estimated number of seconds to wait for an event to happen.
Events include opening a table or starting an ESP process.
DOUBLE PRECISIONEST_IDLE_TIME
Estimated number of seconds to execute the queryDOUBLE PRECISIONEST_TOTAL_TIME
Estimated number of rows that the query will returnDOUBLE PRECISIONEST_CARDINALITY
Process name of the NDCS server (MXOSRVR)VARCHAR(32)PROCESS_NAME
Application ID and computer name delimited by the || characterVARCHAR(200)QUERY_NAME
Client roleVARCHAR(50)ROLE_NAME
Sequential number of the serviceINTSERVICE_INDEX
Sequential number of the queryINTQUERY_INDEX
Timestamp when the query was registered in WMSVARCHAR(26)START_TS
Timestamp when the query was inserted into the serviceVARCHAR(26)ENTRY_TS
Unformatted timestamp when the query was inserted into the
service
LARGEINTENTRY_JTS
Local civil time when the shared memory block was last updatedLARGEINTLAST_UPDATED
• The STATUS QUERIES EXECUTING STATS returns these numbers of executing queries in
various states on each segment of the Neoview platform:
70 WMS Commands