Neoview Workload Management Services Guide (R2.3)

Table A-9 Numbers of Executing Queries on the System
DescriptionData TypeColumn Name
Segment numberINTSEGMENT
Number of executing queries in the initialization state for this segmentINTTOT_INITIAL
Number of executing queries in the open state for this segmentINTTOT_OPEN
Number of executing queries in the end-of-file state for this segmentINTTOT_EOF
Number of executing queries in the close state for this segmentINTTOT_CLOSE
Number of executing queries in the deallocate state for this segmentINTTOT_DEALLOCATED
Number of executing queries in the fetch state for this segmentINTTOT_FETCH
Number of executing queries in the close_tables state for this segmentINTTOT_CLOSE_TABLES
Number of executing queries in the prepare state for this segmentINTTOT_PREPARE
• The STATUS QUERY with STATS, STATUS QUERY ALL STATS, and STATUS QUERIES
ALL STATS return this status information:
Table A-10 Query Runtime Statistics
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
State of the query, which is INIT (for initialization), WAITING,
EXECUTING, or HOLDING
VARCHAR(9)QUERY_STATE
Statement identifier specified by the client applicationVARCHAR(160)STATEMENT_ID
— OTHER
— UNKNOWN
— SELECT_UNIQUE
— SELECT_NON_UNIQUE
— INSERT_UNIQUE
— INSERT_NON_UNIQUE
— UPDATE_UNIQUE
— UPDATE_NON_UNIQUE
— DELETE_UNIQUE
— DELETE_NON_UNIQUE
— CONTROL
— SET_TRANSACTION
— SET_CATALOG
— SET_SCHEMA
— CALL_NO_RESULT_SETS
— CALL_WITH_RESULT_SETS
— SP_RESULT_SET
VARCHAR(21)STATEMENT_TYPE
Compilation start timeLARGEINTCOMP_START_TIME
Compilation end timeLARGEINTCOMP_END_TIME
Execution start timeLARGEINTEXEC_START_TIME
Execution end timeLARGEINTEXEC_END_TIME
STATUS Command 71