beautypg.com

HP Neoview Release 2.3 Software User Manual

Page 36

background image

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name

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.

DATE

SESSION_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)or NCHAR(108)

SESSION_ID

Message sequence number
generated by NDCS.
Numbering starts at 0 and is
incremented by 1 for each new
record.

SMALLINT UNSIGNED

SEQUENCE_NUM

Repository-assigned value.
Used internally.

INTEGER UNSIGNED

METRIC_CLASS_ID

Repository-assigned value.
Used internally.

INTEGER UNSIGNED

METRIC_CLASS_VERSION

Total number of SQL catalog
statements sent by the HP
ODBC driver to the NDCS SQL
server.

LARGEINT

TOTAL_CATALOG_STMTS

Total number of SQL CLOSE
calls sent by the HP ODBC
driver to the NDCS SQL server.

LARGEINT

TOTAL_CLOSES

Total number of SQL DELETE
statements sent by the HP
ODBC driver to the NDCS SQL
server. Does not include
internally generated SQL
statements.

LARGEINT

TOTAL_DELETE_STMTS_EXECUTED

Total number of SQL statement
execution errors detected by the
NDCS SQL server.

LARGEINT

TOTAL_ERRORS

Total number of SQLExecDirect
calls.

LARGEINT

TOTAL_EXECDIRECTS

Total number of SQLExecute
calls.

LARGEINT

TOTAL_EXECUTES

Total number of SQLFetch calls.

LARGEINT

TOTAL_FETCHES

36

Repository Views