Neoview Repository User Guide (R2.4 SP1)

Table 3-1 QUERY_STATS_VW1 Field Definitions
DescriptionData TypeField Name
ANSI Timestamp, in Local Civil Time,
indicating when query execution began. That
is, the time when an execute statement is
issued for the prepared query.
Example: 2009-08-17 07:47:28.795392
TIMESTAMP(6) NO
DEFAULT
EXEC_START_LCT_TS
Primary Key
ANSI Timestamp, in Coordinated Universal
Time, indicating when query execution
began.
Example:2009-08-17 15:47:28.795392
TIMESTAMP(6) NO
DEFAULT
EXEC_START_UTC_TS
Primary Key
A unique identifier for this SQL statement,
generated by the Neoview SQL compiler.
Example:
MXID010010905082121170905693062730000000
26312DEV.USER2400_15010_SQL_CUR_1
CHAR(160) NO
DEFAULT
QUERY_ID
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 such names can map internally to
the same Neoview role.
Example: dbmgr
CHAR(128) DEFAULT
NULL
USER_NAME
Neoview user 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
Query Statistics 23