Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 118)

Table E-6 ODBC_QUERY_STATS_V1 Field Definitions (continued)

DescriptionData TypeField Name

Cumulative number of rows accessed.LARGEINTROWS_ACCESSED

Cumulative number of rows

retrieved.

LARGEINTROWS_RETRIEVED

Number of rows inserted, updated,

deleted.

LARGEINTNUM_ROWS_IUD

Total NDCS server real time, in

microseconds, from the time the

execute or execdirect started to the

time the results were sent back.

LARGEINTQUERY_ELAPSED_TIME

Node processing time.LARGEINTMASTER_EXECUTION_TIME

Total number of executes performed

on this statement.

LARGEINTTOTAL_EXECUTES

Process identification number of the

NDCS server.

INTEGER UNSIGNEDPIN

START if this record contains

information collected at the start of

the query, or END if it contains

statistics collected at the end of the

query.

CANCELLED for queries killed

through Neoview Query Viewer.

CHARACTER(5)STATEMENT_STATUS

Execution priority of the NDCS

process at the time the connection

request is received.

SMALLINT UNSIGNEDSTART_PRIORITY

Prepare error code. A value of 0

indicates that the prepare was

successful.

CHARACTER(6)ERROR_CODE

Client data source name used at the

time of the connection.

CHARACTER(128)DATASOURCE

Client application name or main

window caption.

CHARACTER(130)APPLICATION_ID

Client workstation TCP/IP or

NetBios/network name.

CHARACTER(15)CLIENT_ID

Name of the Neoview segment used

by the data source.

CHARACTER(10)SEGMENT_NAME

Process name of the NDCS server that

is the parent of the query. The format

of this name is

\segment_name.$process_name

(e.g., \NEO0101.$XYZ.

CHARACTER(18)PROCESS_NAME

A deprecated internal representation

of a Neoview role.

CHARACTER(8)USER_ID

The name, used at time of connection,

to identify a Neoview user.

CHARACTER(128)USER_NAME

Unique statement ID generated by

the NDCS SQL server at the time the

Prepare command was received.

CHARACTER(30)STATEMENT_ID

118 Pre-R2.5 Query Statistics Views

1 2 ... 113 114 115 116 117 118 119 120 121 122 123 ... 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 118

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software