HP Neoview Release 2.5 Software - Manual (Page 99)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Query ID for the immediate parent of this
query ID. If the parent query ID is not
present, value returned is NONE.
TIP: You can use the parent query ID to
relate a child SQL statement to an immediate
parent, then trace the relationship to find the
original SQL statement.
CHAR(160) DEFAULT
NULL PARENT_QUERY_ID
ANSI Timestamp in Local Civil Time
indicating when query execution ended.
Example: 2009-08-17 07:47:59.964873 TIMESTAMP(6)
DEFAULT NULL EXEC_END_LCT_TS
ANSI Timestamp in Coordinated Universal
Time indicating when query execution
ended.
Example: 2009-08-17 15:47:59.964873
TIP: You can use this value to monitor
whether the query is still running.
TIMESTAMP(6)
DEFAULT NULL EXEC_END_UTC_TS
Node processing time, in microseconds, from
the time the execution starts to the time the
results are returned. It does not include CPU
time consumed by SQL executor child
processes (ESPs) or disk processes for the
query.
Example: 40214 LARGEINT DEFAULT
NULL MASTER_EXECUTION_TIME
Node processing time, in seconds, from the
time the execution starts to the time the
results are returned. It does not include CPU
time consumed by SQL executor child
processes (ESPs) or disk processes for the
query.
Example: 0.040214 FLOAT(54) DEFAULT
NULL MASTER_EXECUTION_TIME_SEC
Query error code returned to the client. If
the NDCS process stops or fails, this field is
set to 201. In this case, the last statistics
available from WMS are retrievable with this
view. INTEGER DEFAULT
NULL ERROR_CODE
Top–level error code returned by the query.
Values:
• 100 – completed SELECT, UPDATE, or
DELETE statements with actual end
statistics
• zero (0) – completed INSERT queries or
uncompleted queries
• negative number – an execution-type
error
INTEGER DEFAULT
NULL SQL_ERROR_CODE
Message text of the error returned by SQL.
See SQL_ERROR_CODE. CHAR(200) DEFAULT
NULL ERROR_TEXT
Last error code that caused the query to be
automatically retried. INTEGER DEFAULT
NULL LAST_ERROR_BEFORE_AQR
Delay time in seconds before the query was
automatically retried. LARGEINT DEFAULT
NULL DELAY_TIME_BEFORE_AQR_SEC
Total number of times that a query was
retried. LARGEINT DEFAULT
NULL TOTAL_NUM_AQR_RETRIES
Query Statistics for R2.4 SP2 99