Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
185
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
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.154
ONS15454_OTN_Path_PM_Table
The ONS15454_OTN_Path_PM_Table is used for OCN PM data where the module type is
an OCN Line card.
an OCN Line card.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS15454_OTNPATH_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-150: ONS15454_OTN_Path_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID used to access the
ONS15454_OTN_Path_PM_Table; same as
NEDBAccessID in the NE_Info_Table.
ONS15454_OTN_Path_PM_Table; same as
NEDBAccessID in the NE_Info_Table.
ModuleType
NUMBER(4)
NOT NULL
Module type.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEIfIndex
NUMBER(20)
NOT NULL
Table index for the interface. Same as
IfStaticIndex of INTERFACE_TABLE.
IfStaticIndex of 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 (info about PM
stats)
0: Valid Period
Other: Bit Mask Value (info about PM
stats)
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.