Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 33)

Table 3-2 SQL_TEXT_VW1 Field Definitions (continued)

DescriptionData TypeField 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. For example,

NEO01.

CHAR(64) DEFAULT NULLPLATFORM_NAME

Complete SQL Text for a query. 16000

characters are written per row.

TIP: The full SQL text can be joined to

the query statistics by joining on the

QUERY_ID field.

VARCHAR(16000) DEFAULT NULLSQL_TEXT

ODBC Session Data

The two views used for retrieval of ODBC session statistics differ in that one

(NEO.HP_METRICS.ODBC_SESSION_STATS_V1) preserves separate rows for data collected

at the start and end of an ODBC Statement Execute, whereas the other

(NEO.HP_METRICS.ODBC_SESSION_STATS_V2) combines all statistics pertaining to the session

in a single row.

VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1

This view preserves separate rows for data collected at the start and end of a session.

If information is not available for a field (because the record represents the start of a session and

the field is not populated until the end), the value in that field is NULL. To distinguish easily

between start and end records, you can filter results according to the value of SESSION_STATUS.

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 ODBC_SESSION_STATS_V1 field definition is SEGMENT_ID, NODE_ID,

and SESSION_EVENT_DATETIME_UTC.

Table 3-3 ODBC_SESSION_STATS_V1 Field Definitions

DescriptionData TypeField Name

Segment number of the NDCS

server that reported the

statistics.

INTEGER UNSIGNEDSEGMENT_ID

Processing node number of the

NDCS server that generated the

session.

INTEGER UNSIGNEDNODE_ID

ANSI SQL Timestamp, in Local

Civil Time, indicating when the

statistics were recorded in the

Repository.

TIMESTAMP(6)SESSION_EVENT_DATETIME

ANSI SQL date, in Local Civil

Time, when the statistics were

recorded in the Repository.

DATESESSION_EVENT_DATE

ANSI SQL time, in Local Civil

Time, when the statistics were

recorded in the Repository.

TIME(6)SESSION_EVENT_TIME

ODBC Session Data 33

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 33

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software