HP Neoview Release 2.5 Software - Manual (Page 22)

Table 3-1 QUERY_STATS_VW2 Field Definitions (continued)
Description Data Type Field Name
Compiler-provided value, one of:
• SQL_SELECT_UNIQUE
• SQL_SELECT_NON_UNIQUE
• SQL_INSERT_UNIQUE
• SQL_INSERT_NON_UNIQUE
• SQL_UPDATE_UNIQUE
• SQL_UPDATE_NON_UNIQUE
• SQL_DELETE_UNIQUE
• SQL_DELETE_NON_UNIQUE
• SQL_SET_TRANSACTION
• SQL_SET_SCHEMA
• SQL_OTHER
• SQL_CALL_NO_RESULT_SETS
• SQL_CALL_WITH_RESULT_SETS
• SQL_CAT_UTIL
• SQL_EXE_UTIL
• SQL_EXEC_INSERT_RWRS
For definitions of SQL statement types, see
Appendix B: “STATEMENT_TYPE Field”
(page 73)
. The suffix _UNIQUE indicates
that the statement operates on a single row.
The suffix _NON_UNIQUE indicates that
the statement could operate on multiple
rows.
CHARACTER(36)
DEFAULT NULL STATEMENT_TYPE
Name of service registered with Workload
Management Services (WMS).
Example: HP_DEFAULT_SERVICE CHAR(128) DEFAULT
NULL SERVICE_NAME
Segment number of the NDCS server that
reported the statistics.
The Master Executor process for the query
runs in this segment.
Example: 1
INTEGER UNSIGNED
DEFAULT NULL SEGMENT_ID
Processing node number of the NDCS server
that reported the statistics.
Example: 9
SMALLINT UNSIGNED
DEFAULT NULL NODE_ID
ANSI Timestamp, in Local Civil Time,
indicating when the query first entered
Workload Management Services (WMS).
Example: 2009-08-17 07:47:28.795755
TIMESTAMP(6)
DEFAULT NULL SUBMIT_LCT_TS
ANSI Timestamp, in Coordinated Universal
Time, indicating when the query first entered
Workload Management Services (WMS).
Example: 2009-08-17 15:47:28.795755
TIMESTAMP(6)
DEFAULT NULL SUBMIT_UTC_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation began.
That is, when a Prepare statement was issued
for this query.
Example: 2009-08-17 07:47:28.791758
TIMESTAMP(6) NO
DEFAULT COMPILE_START_LCT_TS
22 Repository Views