HP Neoview Release 2.3 Software - Manual (Page 57)

Table 3-11 DISK_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Number of disk process read
operations per second for this interval,
for the mirror disk DECIMAL(9,1) READS_PER_SEC_MIR
Number of disk process write
operations per second for this interval,
for the mirror disk DECIMAL(9,1) WRITES_PER_SEC_MIR
Total number of disk process reads,
writes, and seeks per second for this
interval, for the mirror disk DECIMAL(9,1) OPS_PER_SEC_MIR
Percentage of time that the mirror disk
was busy reading, writing, and seeking
during this interval DECIMAL(6,1) BUSY_PCT_MIR
Percentage of time that the mirror disk
was busy writingduring this interval DECIMAL(6,1) BUSY_WRITES_PCT_MIR
Percentage of time that the mirror disk
was busy reading during this interval DECIMAL(6,1) BUSY_READS_PCT_MIR
Input kilobytes per second during this
interval for the mirror disk DECIMAL(9,1) INPUT_KB_PER_SEC_MIR
Output kilobytes per second during
this interval for the mirror disk DECIMAL(9,1) OUTPUT_KB_PER_SEC_MIR
Timestamp, in Universal Coordinated
Time, when the measurement was
submitted to the Repository TIMESTAMP(6) SUBMIT_TS_UTC
Timestamp, in Local Civil Time, when
the measurement was stored in the
Repository TIMESTAMP(6) UPDATE_TS
Minutes behind or ahead of UTC (can
be a positive or negative number) INTERVAL MINUTE(3) UTC_BIAS
Summary of Field Definition Changes from Repository 2.1
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 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
Summary of Field Definition Changes from Repository 2.1 57