Neoview Repository User Guide (R2.4 SP1)

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)
DescriptionData TypeField Name
Unique session ID generated by the NDCS
server when the ODBC/JDBC connection was
established.
Example:
MXID010010905082121170905693062730000000
26312DEV.USER2400
TIP: The session ID is fully contained
within the query ID. To find all queries
executed within a specific session, join the
session statistics views and the query
statistics view on the session ID.
CHARACTER(108)
DEFAULT NULL
SESSION_ID
Name of the workstation that initiated the
query.
Example: testpc-8
VARCHAR(1024)
DEFAULT NULL
CLIENT_NAME
Name of the application used to connect to
the database and send the query.
Example: NCI.
CHAR(130) DEFAULT
NULL
APPLICATION_NAME
Datasource name on the Neoview platform
to which the client connected.
Example: Admin_Load_DataSource
CHARACTER(128)
DEFAULT NULL
DATASOURCE
Unique statement ID generated by the NDCS
SQL server at the time the Prepare command
was received.
Example: SQL_CUR_1
CHARACTER(160)
DEFAULT NULL
STATEMENT_ID
24 Repository Views