Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
269
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
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.200
ONS15600_POS_PM_Table
The ONS15600_POS_PM_Table is used for POS PM data where the module type is an
ASAP line card.
ASAP line card.
Primary key: ONS15600_POS_PM_PK
Tablespace: ONS15600_DATA_TABLESPACE
Table 1-196: ONS15600_POS_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 for which the TM refers.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEIfIndex
NUMBER(20)
NOT NULL
Table index for the interface.
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
Indicates status of the PM bucket. Values
are:
0: Valid period
Other: Bit mask Value
are:
0: Valid period
Other: Bit mask Value