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

Summary of Field Definition Changes for Repository 2.2

The following field names changed between Repository 2.1 and Repository 2.2. If you have

already modified queries to reflect field names in Repository 2.2, you can ignore this section.

The following table shows how fields defined in the view ACCESS_ODBCMX_QUERY_STATS_V1

were renamed in the view ODBC_QUERY_STATS_V1.

Table F-4 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to

ODBC_QUERY_STATS_V1

Field Name in ODBC_QUERY_STATS_V1Field Name in ACCESS_ODBCMX_QUERY_STATS_V1

NODE_IDCPU_NUM

QUERY_EVENT_DATETIME_UTC,

QUERY_EVENT_DATE_UTC,

QUERY_EVENT_TIME_UTC

ENTRY_ID

QUERY_EVENT_DATETIME, QUERY_EVENT_DATE,

QUERY_EVENT_TIME

ENTRY_ID_LCT

EST_COSTESTIMATED_COST

DISK_READSDISC_READS

LOCK_ESCALATIONSLOCKESCALATIONS

LOCK_WAITSLOCKWAITS

MESSAGE_BYTES_TO_DISKMSGSBYTESTODISC

MESSAGES_TO_DISKMSGSTODISC

QUERY_ELAPSED_TIMEODBC_ELAPSED_TIME

MASTER_EXEC_EXECUTION_TIMEODBC_EXECUTION_TIME

Column Removed - Duplicate of

QUERY_ELAPSED_TIME

TOTAL_ODBC_ELAPSED_TIME

Column Removed - Duplicate of

MASTER_EXEC_EXECUTION_TIME

TOTAL_ODBC_EXECUTION_TIME

SEGMENT_NAMENODENAME

The following table shows how fields defined in the view ACCESS_ODBCMX_QUERY_STATS_V2

were renamed in the view ODBC_QUERY_STATS_V2.

Table F-5 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to

ODBC_QUERY_STATS_V2

Field Name in ODBC_QUERY_STATS_V2Field Name in ACCESS_ODBCMX_QUERY_STATS_V2

SEGMENT_NAMENODENAME

NODE_IDCPU_NUM

STATEMENT_TYPEQUERY_TYPE

STATEMENT_STATEQUERY_STATE

QUERY_START_DATETIME_UTC,

QUERY_START_DATE_UTC,

QUERY_START_TIME_UTC

START_ENTRY_ID

QUERY_START_DATETIME, QUERY_START_DATE,

QUERY_START_TIME

START_ENTRY_ID_LCT

QUERY_END_DATETIME_UTC,

QUERY_END_DATE_UTC, QUERY_END_TIME_UTC

END_ENTRY_ID

Summary of Field Definition Changes for Repository 2.2 135

1 2 ... 130 131 132 133 134 135 136 137 138 139 140 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 135

Kommentare zu diesen Handbüchern

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