HP Neoview Release 2.4 Software User Manual

Page 60

Table 3-12 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to
ODBC_QUERY_STATS_V1

Field Name in ODBC_QUERY_STATS_V1

Field Name in ACCESS_ODBCMX_QUERY_STATS_V1

NODE_ID

CPU_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_COST

ESTIMATED_COST

DISK_READS

DISC_READS

LOCK_ESCALATIONS

LOCKESCALATIONS

LOCK_WAITS

LOCKWAITS

MESSAGE_BYTES_TO_DISK

MSGSBYTESTODISC

MESSAGES_TO_DISK

MSGSTODISC

QUERY_ELAPSED_TIME

ODBC_ELAPSED_TIME

MASTER_EXEC_EXECUTION_TIME

ODBC_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_NAME

NODENAME

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 3-13 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2

Field Name in ODBC_QUERY_STATS_V2

Field Name in ACCESS_ODBCMX_QUERY_STATS_V2

SEGMENT_NAME

NODENAME

NODE_ID

CPU_NUM

STATEMENT_TYPE

QUERY_TYPE

STATEMENT_STATE

QUERY_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

QUERY_END_DATETIME, QUERY_END_DATE,
QUERY_END_TIME

END_ENTRY_ID_LCT