HP Neoview Release 2.3 Software - Manual (Page 35)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
ANSI Timestamp, in Local Civil Time,
indicating when query execution
began. If the query has not yet begun
execution, the value is NULL. TIMESTAMP(6) NO DEFAULT EXEC_START_TS
ANSI Timestamp indicating when
query execution ended, converted to
LCT from UTC. If the query has not
yet begun execution, the value is
NULL. TIMESTAMP(6) NO DEFAULT EXEC_END_TS
ODBC Session Data
The two views used for retrieval of ODBC session statistics differ in that one
(NEO.HP_METRICS.ODBC_SESSION_STATS_V1) preserves separate rows for data collected
at the start and end of an ODBC Statement Execute, whereas the other
(NEO.HP_METRICS.ODBC_SESSION_STATS_V2) combines all statistics pertaining to the session
in a single row.
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1
This view preserves separate rows for data collected at the start and end of a session.
If information is not available for a field (because the record represents the start of a session and
the field is not populated until the end), the value in that field is NULL. To distinguish easily
between start and end records, you can filter results according to the value of SESSION_STATUS.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. In the following table:
• If a data type is given as CHAR or NCHAR, then CHAR applies if the character set is
ISO88591, and NCHAR applies if the character set is UCS2.
• If a data type is given as VARCHAR or NCHAR VARYING, the VARCHAR applies if the
character set is ISO88591, and NCHAR VARYING applies if the character set is UCS2.
Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions
Description Data Type Field Name
Segment number of the NDCS
server that reported the
statistics. INTEGER UNSIGNED SEGMENT_ID
Processing node number of the
NDCS server that generated the
session. INTEGER UNSIGNED NODE_ID
ANSI SQL Timestamp, in Local
Civil Time, indicating when the
statistics were recorded in the
Repository. TIMESTAMP(6) SESSION_EVENT_DATETIME
ANSI SQL date, in Local Civil
Time, when the statistics were
recorded in the Repository. DATE SESSION_EVENT_DATE
ANSI SQL time, in Local Civil
Time, when the statistics were
recorded in the Repository. TIME(6) SESSION_EVENT_TIME
ODBC Session Data 35