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

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)

DescriptionData TypeField Name

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

the Neoview SQL Reference Manual. For

example, to find information about

SQL_SET_TRANSACTION, look up the SET

TRANSACTION statement in the Neoview

SQL Reference Manual. 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

ANSI Timestamp, in Coordinated Universal

Time, indicating when the query first entered

Workload Management Services (WMS).

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

TIMESTAMP(6)

DEFAULT NULL

SUBMIT_UTC_TS

22 Repository Views

1 2 ... 17 18 19 20 21 22 23 24 25 26 27 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 22

Comentarios a estos manuales

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