HP Neoview Release 2.5 Software - Manual (Page 89)

E Pre-R2.5 Query Statistics Views
Query Statistics for R2.4 SP2
VIEW NEO.HP_METRICS.QUERY_STATS_VW1
Repository collects compilation and execution query statistics.
This view provides access to all query information. The SQL text for the query is also included,
up to 254 characters. If the SQL text is longer than 254 characters, the
SQL_TEXT_OVERFLOW_INDICATOR
field is set to 1 to indicate that only part of the SQL text fits
in this view, and the complete SQL text is placed in the SQL_TEXT_VW1 view. In this case,
QUERY_STATS_VW1 has the first 254 characters and SQL_TEXT_VW1 has the complete SQL
text. The QUERY_STATS_VW1 view can be joined with the SQL_TEXT_VW1 view through the
EXEC_START_LCT_TS (or EXEC_START_UTC_TS) and QUERY_ID fields to fetch the full SQL
text for the query.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The Primary Key for QUERY_STATS_VW1 field definition is EXEC_START_UTC_TS and
QUERY_ID.
Table E-1 QUERY_STATS_VW1 Field Definitions
Description Data Type Field 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
Query Statistics for R2.4 SP2 89