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

Table 3-1 QUERY_STATS_VW2 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_SET_TRANSACTION

• SQL_SET_SCHEMA

• SQL_OTHER

• SQL_CALL_NO_RESULT_SETS

• SQL_CALL_WITH_RESULT_SETS

• SQL_CAT_UTIL

• SQL_EXE_UTIL

• SQL_EXEC_INSERT_RWRS

For definitions of SQL statement types, see

Appendix B: “STATEMENT_TYPE Field”

(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

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

ANSI Timestamp, in Local Civil Time,

indicating when query compilation began.

That is, when a Prepare statement was issued

for this query.

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

TIMESTAMP(6) NO

DEFAULT

COMPILE_START_LCT_TS

22 Repository Views

1 2 ... 17 18 19 20 21 22 23 24 25 26 27 ... 141 142

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.5 Software Manual de usuario Pagina 22

Comentarios a estos manuales

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