Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
224
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
thresholdList
VARCHAR2(102
4)
4)
—
Threshold value for the PM bucket for the
day.
day.
CodeViolations NUMBER(10)
DEFAULT –1
Coding violation line.
ErrSecs
NUMBER(10)
DEFAULT –1
Errored seconds line.
SevErrSecs
NUMBER(10)
DEFAULT –1
Severely errored seconds line.
UnavailableSec
s
s
NUMBER(10)
DEFAULT –1
Unavailable seconds line.
BackGroundBlo
ckErrors
ckErrors
NUMBER(10)
DEFAULT –1
Background block errors line.
ESR
NUMBER(10)
DEFAULT –1
Errored seconds ratio line.
SESR
NUMBER(10)
DEFAULT –1
Severely errored seconds ratio line.
BBER
NUMBER(10)
DEFAULT –1
Background block errors ratio.
IS24H
NUMBER(1)
NOT NULL
Whether the PM data is collected in 24-
hour or 15-minute increments. Values are:
1: 24 hour
0: 15-minute
hour or 15-minute increments. Values are:
1: 24 hour
0: 15-minute
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Object type.
StrObjInstance
VARCHAR2(256
)
)
—
StrObjInstance name.
InvalidityList
VARCHAR2(102
4)
4)
—
Invalidity list for PM data.
StrCorbaTIDAI
D
D
VARCHAR2(512
)
)
—
Stores the TL1 target identifier (TID) value
returned by the getCTMHistoryPMData
API for each physical termination point
(PTP). The getCTMHistoryPMData API
stores the historical PM data output in a
.csv file. The PTP native name is one of the
output parameters displayed in this file. It
contains the rack, shelf, slot, and port
information for the PTP. It also contains
pluggable port module (PPM) information,
if applicable.
returned by the getCTMHistoryPMData
API for each physical termination point
(PTP). The getCTMHistoryPMData API
stores the historical PM data output in a
.csv file. The PTP native name is one of the
output parameters displayed in this file. It
contains the rack, shelf, slot, and port
information for the PTP. It also contains
pluggable port module (PPM) information,
if applicable.
1.1.169
ONS15454SDH_HO_PM_Table
The ONS15454SDH_HO_PM_Table stores high-order (HO) PM information about
ONS 15454 SDH NEs.
ONS 15454 SDH NEs.
For medium, large, and high-end configurations, this table is partitioned.