HP Neoview Release 2.5 Software - Manual (Page 91)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Datasource name on the Neoview platform
to which the client connected.
Example: Admin_Load_DataSource CHARACTER(128)
DEFAULT NULL DATASOURCE
Unique statement ID generated by the NDCS
SQL server at the time the Prepare command
was received.
Example: SQL_CUR_1 CHARACTER(160)
DEFAULT NULL STATEMENT_ID
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_CONTROL
• SQL_SET_TRANSACTION
• SQL_SET_CATALOG
• SQL_SET_SCHEMA
• SQL_OTHER
• SQL_UNKNOWN
• SQL_CALL_NO_RESULT_SETS
• SQL_CALL_WITH_RESULT_SETS
• SQL_SP_RESULT_SET
• SQL_CAT_UTIL
• SQL_EXE_UTIL
• SQL_NOT_SUPPORTED
For definitions of SQL statement types, see
Appendix B (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
Query Statistics for R2.4 SP2 91