Neoview Workload Management Services Guide (R2.4)

Table A-11 Query Compile-Time Statistics (continued)
DescriptionData TypeColumn Name
The estimated number of rows that will be
accessed by all the scan, insert, update, and
delete operators in the query plan.
DOUBLE
PRECISION
CMP_DP2_ROWS_ACCESSED
The estimated number of rows that will be
accessed by scan and insert operators in the
query plan.
DOUBLE
PRECISION
CMP_DP2_ROWS_USED
The process name of the NDCS server
(MXOSRVR)
VARCHAR(32)PROCESS_NAME
Application ID and computer name
delimited by the || character
VARCHAR(200)QUERY_NAME
The client role nameVARCHAR(50)ROLE_NAME
LOW, MEDIUM, HIGH, or blank when no
warnings exist for the query. If more than
one warning level exists for the query, the
highest warning level appears here.
VARCHAR(6)WARN_LEVEL
Local civil time when the query was
registered in WMS. YYYY-DD-MM
HH:MM:SS.aaabbb (aaa=milliseconds,
bbb=microseconds)
VARCHAR(26)START_TS
Local civil time when the query was
inserted into the service. YYYY-DD-MM
HH:MM:SS.aaabbb (aaa=milliseconds,
bbb=microseconds)
VARCHAR(26)ENTRY_TS
Unformatted local civil time when the query
was inserted into the service.
YYYY-DD-MM HH:MM:SS.aaabbb
(aaa=milliseconds, bbb=microseconds)
LARGEINTENTRY_JTS
Local civil time when the shared memory
block was last updated
LARGEINTLAST_UPDATED
• The STATUS QUERIES WARN command returns this status information:
Table A-12 Query Warning Information
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
Service name of the queryVARCHAR(96)SERVICE_NAME
CONN, COMP, or EXECVARCHAR(4)WARN_TYPE
LOW, MEDIUM, HIGHVARCHAR(6)WARN_LEVEL
Name of the rule that triggered the warningVARCHAR(96)RULE_NAME
Expression number in the rule, corresponding to the ordinal
position of the expression for an OR operator or the total number
of expressions for an AND operator
INTEXPR
Rule expression that triggered the warningVARCHAR(512)REASON
• The STATUS QUERIES command with ALL STATS returns this status information:
STATUS QUERIES Command 131