Neoview Repository User Guide (R2.4 SP1)

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-7 ODBC_SESSION_STATS_V1 Field Definitions
DescriptionData TypeField Name
Segment number of the NDCS
server that reported the
statistics.
INTEGER UNSIGNEDSEGMENT_ID
Processing node number of the
NDCS server that generated the
session.
INTEGER UNSIGNEDNODE_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.
DATESESSION_EVENT_DATE
ANSI SQL time, in Local Civil
Time, when the statistics were
recorded in the Repository.
TIME(6)SESSION_EVENT_TIME
ANSI SQL Timestamp, in
Coordinated Universal Time,
indicating when the statistics
were recorded in the
Repository.
TIMESTAMP(6)SESSION_EVENT_DATETIME_UTC
ANSI SQL date, in Coordinated
Universal Time, when the
statistics were recorded in the
Repository.
DATESESSION_EVENT_DATE_UTC
ANSI SQL time, in Coordinated
Universal Time, when the
statistics were recorded in the
Repository.
TIME(6)SESSION_EVENT_TIME_UTC
Unique session ID generated by
the NDCS server when the
connection was established. For
information about the format,
see the note after this table.
CHAR(108)SESSION_ID
Message sequence number
generated by NDCS.
Numbering starts at 0 and is
incremented by 1 for each new
record.
SMALLINT UNSIGNEDSEQUENCE_NUM
Repository-assigned value.
Used internally.
INTEGER UNSIGNEDMETRIC_CLASS_ID
Repository-assigned value.
Used internally.
INTEGER UNSIGNEDMETRIC_CLASS_VERSION
Total number of SQL catalog
statements sent by the HP
ODBC driver to the NDCS SQL
server.
LARGEINTTOTAL_CATALOG_STMTS
ODBC Session Data 51