Neoview Repository User Guide (R2.4 SP2)

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.
If the query is controlled by WMS, this value
reflects the time it was ready to be submitted
to the WMS system. Depending on WMS
rules and threshold settings, WMS may delay
or cancel the actual launch of the query.
Columns SUBMIT_TS_LCT, WAIT_TIME
and HOLD_TIME can be used to calculate
the actual launch time of the query.
If the query is not under control of WMS,
EXEC_START_LCT_TS represents the actual
launch time.
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:
MXID0100109050821211709056930627300
0000026312DEV.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 users can have the same Neoview
role.
Example: dbmgr
CHAR(128) DEFAULT
NULL
USER_NAME
20 Repository Views