Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
236
1.1.172
ONS15454SDH_RS_PM_Table
The ONS15454SDH_RS_PM_Table stores regenerator section (RS) PM information about
ONS 15454 SDH NEs.
ONS 15454 SDH NEs.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS15454SDH_RS_PM_TABLE_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-168: ONS15454SDH_RS_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 the NE_INFO_TABLE.
NEDBAccessID in the 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
Table index for the interface; same as
IfStaticIndex in the Interface_Table.
IfStaticIndex in the Interface_Table.
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)
DEFAULT 0
Status of the PM bucket. Values are:
0: Valid period
Other: Bit mask value (information about
PM statistics)
0: Valid period
Other: Bit mask value (information about
PM statistics)
inMaintenance NUMBER(1)
—
Whether the NE was under maintenance
when the PM bucket was collected.
when the PM bucket was collected.
fifteenMinThre
sholdMask
sholdMask
NUMBER(10)
—
Threshold value for the PM bucket for the
15-minute interval.
15-minute interval.
thresholdList
VARCHAR2(102
4)
4)
—
Threshold value for the PM bucket for the
day.
day.
RsEb
NUMBER(10)
DEFAULT –1
RS EB indicates that one or more bits are
in error within a block.
in error within a block.
RsEs
NUMBER(10)
DEFAULT –1
RS ES is a 1-second period with one or
more errored blocks or at least one
defect.
more errored blocks or at least one
defect.
RsSes
NUMBER(10)
DEFAULT –1
RS SES is a 1-second period which contains
greater than 30 percent errored blocks or
at least one defect. SES is a subset of ES.
greater than 30 percent errored blocks or
at least one defect. SES is a subset of ES.
RsBbe
NUMBER(10)
DEFAULT –1
RS BBE is an errored block not occurring
as part of an SES.
as part of an SES.
RsSefs
NUMBER(10)
DEFAULT –1
RS SEFS is a count of the number of SEFSs