Cisco Cisco Prime Optical 9.6 Références techniques
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
148
The active package is used by the Prime Optical client to launch CTC. The Preferred-jar-
path value in the CTM_Config_Table points to the entry in the
ONS15454_CMS_Storage_Table that is active at that time.
path value in the CTM_Config_Table points to the entry in the
ONS15454_CMS_Storage_Table that is active at that time.
Primary key: ONS15454_CMS_STORAGE_TABLE_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-136: ONS15454_CMS_Storage_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
JarID
NUMBER(4)
NOT NULL
Running number that is incremented by
one for each insertion into the table.
one for each insertion into the table.
FileName
VARCHAR2(128)
NOT NULL
Used to store the system recommended
JAR file version number.
JAR file version number.
JarTime
DATE
NOT NULL
Date of the JAR.
UserName
VARCHAR2(128)
NOT NULL
User profile when JAR file is active.
1.1.141
ONS15454_COS_PM_Table
The ONS15454_COS_PM_Table contains historical PM data collected in each interface
and class of service level for the ML-series cards of CTC-based NEs.
and class of service level for the ML-series cards of CTC-based NEs.
Primary key: ONS15454_COS_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-137 : ONS15454_COS_PM_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE; same
as NEDBAccessID in the NE table.
as NEDBAccessID in the NE table.
ModuleType
NUMBER(4)
NOT NULL
Module type to which the PM 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
Values are:
0: Valid period
Other: Bit mask value
inMaintenance
NUMBER(1)
—
Whether the NE was under
maintenance when the PM bucket
was collected.
maintenance when the PM bucket
was collected.