HP Neoview Release 2.3 Software - Manual (Page 59)

Table 3-14 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 to
ODBC_SESSION_STATS_V1.
Field Name in ODBC_SESSION_STATS_V1 Field Name in ACCESS_ODBCMX_SESSION_DATA_V1
NODE_ID CPU_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_TIME TOTAL_ODBC_EXECUTION_TIME
Column Removed END_TIME
SEGMENT_NAME NODENAME
Column Removed START_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 3-15 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2
Field Name in ODBC_SESSION_STATS_V2 Field Name in ACCESS_ODBCMX_SESSION_DATA_V2
SEGMENT_NAME NODENAME
NODE_ID CPU_NUM
SESSION_START_DATETIME_UTC,
SESSION_START_DATE_UTC,
SESSION_START_TIME_UTC START_ENTRY_ID
SESSION_START_DATETIME, SESSION_START_DATE,
SESSION_START_TIME START_ENTRY_ID_LCT
SESSION_END_DATETIME_UTC,
SESSION_END_DATE_UTC, SESSION_END_TIME_UTC END_ENTRY_ID
SESSION_END_DATETIME, SESSION_END_DATE,
SESSION_END_TIME END_ENTRY_ID_LCT
Column Removed - Duplicate of SESSION_START_TIME START_TIME
Column Removed - Duplicate of SESSION_END_TIME END_TIME
TOTAL_MASTER_EXEC_EXECUTION_TIME TOTAL_ODBC_EXECUTION_TIME
Summary of Field Definition Changes from Repository 2.2
This section describes field definition changes between Repository 2.2 and Repository 2.3.
The following table shows how fields defined in the view QUERY_RUNTIME_STATS_V1 were
renamed in Repository 2.3.
Table 3-16 Changes in Field Definitions for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to
Repository 2.3
Change in Repository 2.3 Field Name in Repository 2.2
Now has data type INTERVAL SECOND(12,6). SQL_PROCESS_BUSY_TIME
Now has data type INTERVAL SECOND(12,6). QUE_TIME
Summary of Field Definition Changes from Repository 2.2 59