HP Neoview Release 2.4 Software - Manual (Page 33)

Table 3-2 SQL_TEXT_VW1 Field Definitions (continued)
Description Data Type Field Name
Neoview system name, made up of the
first three letters of the system name,
followed by 01 for the first platform at
your site, 02 for the second platform at
your site, and so on. For example,
NEO01. CHAR(64) DEFAULT NULL PLATFORM_NAME
Complete SQL Text for a query. 16000
characters are written per row.
TIP: The full SQL text can be joined to
the query statistics by joining on the
QUERY_ID field.
VARCHAR(16000) DEFAULT NULL SQL_TEXT
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. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for ODBC_SESSION_STATS_V1 field definition is SEGMENT_ID, NODE_ID,
and SESSION_EVENT_DATETIME_UTC.
Table 3-3 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 33