Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
179
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
rttMonStatsO
WSum2DSHigh
WSum2DSHigh
NUMBER(20)
DEFAULT –1
—
rttMonStatsO
WMinDS
WMinDS
NUMBER(20)
DEFAULT –1
—
rttMonStatsO
WMaxDS
WMaxDS
NUMBER(20)
DEFAULT –1
—
rttMonStatsNu
mOfOW
mOfOW
NUMBER(20)
DEFAULT –1
—
rttMonStatsO
WMinSDNew
WMinSDNew
NUMBER(20)
DEFAULT –1
—
StatsLineLastCl
earedTime
earedTime
DATE
—
IS24H
NUMBER(1)
NOT Null
Specifies whether the PM data is a 24-
hour or 15-minute PM data collection.
Values are:
1: 24 hour
0: 15 minute
hour or 15-minute PM data collection.
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.150
ONS15454_LAG_PM_Table
The ONS15454_LAG_PM_Table is used for is used for ML card CB QOS PM data.
Primary key: ONS15454_LAG_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE