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

This table indicates which fields are present for completed and incomplete queries. The source

of data fields indicates whether the value is collected at the start of the query or at the end. Unless

indicated here, field descriptions are those provided above for ODBC_QUERY_STATS_V1.

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_QUERY_STATS_V2 fields is SEGMENT_ID, NODE_ID,

SEQUENCE_NUM and the date/time fields (QUERY_START_DATETIME_UTC and the other

date fields.

Table C-3 ODBC_QUERY_STATS_V2_2400 Fields

Source and NotesData TypeIncomplete QueriesComplete Queries

STARTCHAR(10)SEGMENT_NAMESEGMENT_NAME

STARTINT

UNSIGNED

SEGMENT_IDSEGMENT_ID

STARTINT

UNSIGNED

NODE_IDNODE_ID

Derived from CPU,

INT

UNSIGNED

PINPIN

STARTSMALLINT

UNSIGNED

START_PRIORITY

STARTCHAR(18)PROCESS_NAMEPROCESS_NAME

STARTCHAR(108)SESSION_IDSESSION_ID

STARTCHAR(8)USER_IDUSER_ID

STARTCHAR(128)USER_NAMEUSER_NAME

STARTCHAR(15)CLIENT_IDCLIENT_ID

STARTCHAR(130)APPLICATION_IDAPPLICATION_ID

STARTCHAR(128)DATASOURCEDATASOURCE

ENDVARCHAR(160)QUERY_ID when availableQUERY_ID

STARTCHAR(30)STATEMENT_IDSTATEMENT_ID

ENDCHAR(36)STATEMENT_TYPESTATEMENT_TYPE

'COMPLETE',

'INCOMPLETE',

'MULTIROW',

'ERRTERMINATION',

derived from

STATEMENT

STATUS and

SEQUENCE

NUMBER

CHAR(14)STATEMENT_STATESTATEMENT_STATE

Y or NCHAR(1)QUERY_TEXT_IS_MULTIROWQUERY_TEXT_IS_MULTIROW

END, else START,

else NULL

CHAR(6)ERROR_CODEERROR_CODE

STARTSMALLINT

UNSIGNED

SEQUENCE_NUMSEQUENCE_NUM

STARTSMALLINT

UNSIGNED

SEQUENCE_SIZESEQUENCE_SIZE

90 Pre-R2.4 SP2 Query Statistics Views

1 2 ... 85 86 87 88 89 90 91 92 93 94 95 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 90

Comentarios a estos manuales

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