Hp Neoview Release 2.5 Software Manual de usuario descargar pdf (Pagina 91)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Datasource name on the Neoview platform

to which the client connected.

Example: Admin_Load_DataSource

CHARACTER(128)

DEFAULT NULL

DATASOURCE

Unique statement ID generated by the NDCS

SQL server at the time the Prepare command

was received.

Example: SQL_CUR_1

CHARACTER(160)

DEFAULT NULL

STATEMENT_ID

Compiler-provided value, one of:

• SQL_SELECT_UNIQUE

• SQL_SELECT_NON_UNIQUE

• SQL_INSERT_UNIQUE

• SQL_INSERT_NON_UNIQUE

• SQL_UPDATE_UNIQUE

• SQL_UPDATE_NON_UNIQUE

• SQL_DELETE_UNIQUE

• SQL_DELETE_NON_UNIQUE

• SQL_CONTROL

• SQL_SET_TRANSACTION

• SQL_SET_CATALOG

• SQL_SET_SCHEMA

• SQL_OTHER

• SQL_UNKNOWN

• SQL_CALL_NO_RESULT_SETS

• SQL_CALL_WITH_RESULT_SETS

• SQL_SP_RESULT_SET

• SQL_CAT_UTIL

• SQL_EXE_UTIL

• SQL_NOT_SUPPORTED

For definitions of SQL statement types, see

Appendix B (page 73). The suffix _UNIQUE

indicates that the statement operates on a

single row. The suffix _NON_UNIQUE

indicates that the statement could operate

on multiple rows.

CHARACTER(36)

DEFAULT NULL

STATEMENT_TYPE

Name of service registered with Workload

Management Services (WMS).

Example: HP_DEFAULT_SERVICE

CHAR(128) DEFAULT

NULL

SERVICE_NAME

Segment number of the NDCS server that

reported the statistics.

The Master Executor process for the query

runs in this segment.

Example: 1

INTEGER UNSIGNED

DEFAULT NULL

SEGMENT_ID

Processing node number of the NDCS server

that reported the statistics.

Example: 9

SMALLINT UNSIGNED

DEFAULT NULL

NODE_ID

ANSI Timestamp, in Local Civil Time,

indicating when the query first entered

Workload Management Services (WMS).

Example: 2009-08-17 07:47:28.795755

TIMESTAMP(6)

DEFAULT NULL

SUBMIT_LCT_TS

Query Statistics for R2.4 SP2 91

1 2 ... 86 87 88 89 90 91 92 93 94 95 96 ... 141 142

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.5 Software Manual de usuario Pagina 91

Comentarios a estos manuales

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