Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
246
1.1.183
ONS155xx_Ether_Hist_PM_Table
The ONS155xx_Ether_Hist_PM_Table contains Ethernet RMON history PM data for the
ONS 15501, ONS 15530, and ONS 15540.
ONS 15501, ONS 15530, and ONS 15540.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS155xx_Ether_Hist_PK
Tablespace: ONS155xx_DATA_TABLESPACE
Table 1-179: ONS155xx_Ether_Hist_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE; same as
NEDBAccessID in NE_INFO_TABLE.
NEDBAccessID in NE_INFO_TABLE.
ModuleType
NUMBER(4)
NOT NULL
Module type to which this PM pertains.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEIfIndex
NUMBER(20)
NOT NULL
Interface index as defined by
ObjectMapper.
ObjectMapper.
Interval
NUMBER(1)
NOT NULL
Interval of the PM bucket. Values are:
0: 15 minutes
1: 1-day
0: 15 minutes
1: 1-day
TimeStamp
DATE
NOT NULL
Time stamp that shows the interval at
which the set of statistics was stored.
which the set of statistics was stored.
NEIfPMStatus
NUMBER(20)
NOT NULL
Indicates status of the PM bucket. Values
are:
1: Invalid—Not enough elapsed time
2: Valid period
3: Partial PM (enabled/disabled in this
period)
4: Invalid PM disabled
are:
1: Invalid—Not enough elapsed time
2: Valid period
3: Partial PM (enabled/disabled in this
period)
4: Invalid PM disabled
InMaintenance
NUMBER(1)
—
Whether the NE was under maintenance
when the PM bucket was collected.
when the PM bucket was collected.
ThresholdMask
NUMBER(20)
—
Threshold mask for the PM bucket in the
interval.
interval.
Octets
NUMBER(20)
—
Number of data octets received
(including bad packets and FCS octets,
but excluding framing bits).
(including bad packets and FCS octets,
but excluding framing bits).
Pkts
NUMBER(20)
—
Number of packets (including bad
packets) received during this sampling
interval.
packets) received during this sampling
interval.