Neoview Repository User Guide (R2.4 SP1)

Table C-2 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2 (continued)
Field Name in ODBC_QUERY_STATS_V2Field Name in ACCESS_ODBCMX_QUERY_STATS_V2
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
EST_COSTESTIMATED_COST
QUERY_ELAPSED_TIMEODBC_ELAPSED_TIME
MASTER_EXEC_EXECUTION_TIMEODBC_EXECUTION_TIME
DISK_READSDISC_READS
LOCK_ESCALATIONSLOCKESCALATIONS
LOCK_WAITSLOCKWAITS
MESSAGE_BYTES_TO_DISKMSGSBYTESTODISC
MESSAGES_TO_DISKMSGSTODISC
The following table shows how fields defined in the view
ACCESS_ODBCMX_SESSION_DATA_V1 were renamed in the view ODBC_SESSION_STATS_V1.
Table C-3 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 to
ODBC_SESSION_STATS_V1.
Field Name in ODBC_SESSION_STATS_V1Field Name in ACCESS_ODBCMX_SESSION_DATA_V1
NODE_IDCPU_NUM
SESSION_EVENT_DATETIME_UTC,
SESSION_EVENT_DATE_UTC,
SESSION_EVENT_TIME_UTC
ENTRY_ID
SESSION_EVENT_DATETIME, SESSION_EVENT_DATE,
SESSION_EVENT_TIME
ENTRY_ID_LCT
TOTAL_MASTER_EXEC_EXECUTION_TIMETOTAL_ODBC_EXECUTION_TIME
Column RemovedEND_TIME
SEGMENT_NAMENODENAME
Column RemovedSTART_TIME
The following table shows how fields defined in the view
ACCESS_ODBCMX_SESSION_DATA_V2 were renamed in the view ODBC_SESSION_STATS_V2.
Table C-4 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2
Field Name in ODBC_SESSION_STATS_V2Field Name in ACCESS_ODBCMX_SESSION_DATA_V2
SEGMENT_NAMENODENAME
NODE_IDCPU_NUM
116 History of Changes for Repository