HP Neoview Release 2.4 Software - Manual (Page 21)

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Neoview user role name. Multiple users can
have the same role name.
Example: DBA
CHAR(128) DEFAULT
NULL ROLE_NAME
Starting priority of the Master Executor
process for this query.
Example: 148 INTEGER UNSIGNED
DEFAULT NULL START_PRIORITY
Process name of the NDCS server that is the
parent of the query. The format of this name
is \segment_name.$process_name.
Example: \NEO0101.$XYZ
CHAR(64) DEFAULT
NULL PROCESS_NAME
Unique session ID generated by the NDCS
server when the ODBC/JDBC connection was
established.
Example: :
MXID010010905082121170905693062
73000000026312DEV.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
Query Statistics 21