Cisco Cisco Prime Optical 9.6 Références techniques
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
147
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
ModuleType
NUMBER(4)
NOT NULL
Module type to which the PM
refers.
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.
interval at 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
bucket. 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.
CBQosCMPrePolicyPkt64
NUMBER(20)
DEFAULT 0
—
CBQosCMPrePolicyByte64
NUMBER(20)
DEFAULT 0
—
CBQosCMPostPolicyByte64 NUMBER(20)
DEFAULT 0
—
CBQosCMDropPkt64
NUMBER(20)
DEFAULT 0
—
CBQosCMDropByte64
NUMBER(20)
DEFAULT 0
—
CBQosCMNoBufDropPkt64 NUMBER(20)
DEFAULT 0
—
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
collected in 24-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(1024) —
Invalidity list for PM data.
1.1.140
ONS15454_CMS_Storage_Table
The ONS15454_CMS_Storage_Table stores information about the CTC binary. The table
can have multiple entries; each entry indicates a different CTC package that was
manually uploaded by the user. At any one time, only one of the packages can be active.
can have multiple entries; each entry indicates a different CTC package that was
manually uploaded by the user. At any one time, only one of the packages can be active.