HP Neoview Release 2.4 Software - Manual (Page 22)

Table 3-1 QUERY_STATS_VW1 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_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
the Neoview SQL Reference Manual. For
example, to find information about
SQL_SET_TRANSACTION, look up the SET
TRANSACTION statement in the Neoview
SQL Reference Manual. 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
22 Repository Views