HP Neoview Release 2.5 Software - Manual (Page 90)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Repository-generated ANSI Timestamp, in
Local Civil Time, showing when this row
was last updated.
Example: 2009-08-17 07:48:09.967095 TIMESTAMP(6) NO
DEFAULT ENTRY_ID_LCT_TS
Repository-generated ANSI Timestamp, in
Coordinated Universal Time, showing when
this row was last updated.
Example: 2009-08-17 15:48:09.967095 TIMESTAMP(6) NO
DEFAULT ENTRY_ID_UTC_TS
Name of the Neoview platform segment
used by the datasource to connect and start
the query. The Master Executor process for
the query is running in this segment.
Example: \NEO0101
CHAR(16) DEFAULT
NULL SEGMENT_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.
Example: NEO01 CHAR(64) DEFAULT
NULL PLATFORM_NAME
The name or alias, used at time of
connection, to identify a Neoview user. One
or more users can have the same Neoview
role.
Example: dbmgr
CHAR(128) DEFAULT
NULL USER_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
90 Pre-R2.5 Query Statistics Views