Neoview Repository User Guide (R2.4 SP2)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software

VIEW NEO.HP_METRICS.SQL_TEXT_VW1

This view allows access to the complete SQL text for a query.

When the SQL text for a query is 254 characters or fewer, the text is written to the

QUERY_STATS_VW1 view and the SQL_TEXT_OVERFLOW_INDICATOR field is set to 0. If the

text is longer, the first 254 characters are written to QUERY_STATS_VW1 and

SQL_TEXT_OVERFLOW_INDICATOR is set to 1, indicating that the complete SQL text is found

in the SQL_TEXT field of SQL_TEXT_VW1. In SQL_TEXT_VW1, each row of SQL text can contain

up to 16000 characters. If the complete query text is written across multiple rows,

FRAGMENT_NUMBER is incremented for each row, starting with 0.

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 SQL_TEXT_VW1 field definition is QUERY_ID and FRAGMENT_NUMBER.

Table 3-2 SQL_TEXT_VW1 Field Definitions

DescriptionData TypeField Name

Primary Key

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: 2010–02–02 07:47:28.795392

TIMESTAMP(6) NO DEFAULTEXEC_START_LCT_TS

Primary Key

ANSI timestamp, in Coordinated

Universal Time, indicating when query

execution began.

Example: 2010–02–02 15:47:28.795392

TIMESTAMP(6) NO DEFAULTEXEC_START_UTC_TS

Primary Key

A unique identifier for this SQL

statement, generated by Neoview SQL

compiler.

CHAR(160) NO DEFAULTQUERY_ID

Primary Key

Number of the row for a section of

query text, starting with zero (0). 16000

characters of query text are written per

row.

SMALLINT UNSIGNED NO

DEFAULT

FRAGMENT_NUMBER

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.

CHAR(16) DEFAULT NULLSEGMENT_NAME

32 Repository Views