Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
263
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
IsWorking
NUMBER(1)
DEFAULT 1
Whether the entire path is configured to
be working. Values are:
1: True
2: False
be working. Values are:
1: True
2: False
IsActive
NUMBER(1)
DEFAULT 1
Whether the entire path is configured to
be active. Values are:
1: True
2: False
be active. Values are:
1: True
2: False
DownInterface
s
s
VARCHAR2(256
)
)
DEFAULT NULL
List of all interfaces that are down in the
path.
path.
PathDescr
VARCHAR2(256
)
)
DEFAULT NULL
Description associated with the path.
PathDestPwrM
onNodeId
onNodeId
NUMBER(10)
DEFAULT –1
Node ID where the path destination
power is monitored.
power is monitored.
PathDestPwrM
onPhysicalLoc
onPhysicalLoc
NUMBER(20)
DEFAULT –1
Physical location of the power monitor
endpoint.
endpoint.
PathDestPwrM
onIfIndex
onIfIndex
NUMBER(20)
DEFAULT –1
Static Prime Optical IfIndex of the power
monitor endpoint.
monitor endpoint.
PathDestPwrM
onModuleType
onModuleType
NUMBER(8)
DEFAULT –1
Module type of the power monitor
endpoint.
endpoint.
PathDestPwrM
onObjectType
onObjectType
NUMBER(8)
DEFAULT –1
Prime Optical object type of the power
monitor endpoint.
monitor endpoint.
PathDestPwrM
onModelType
onModelType
NUMBER(8)
—
Prime Optical model type of the power
monitor endpoint.
monitor endpoint.
1.1.197
ONS155xx_Phy_PM_Table
The ONS155xx_Phy_PM_Table contains ONS 15501, ONS 15530, and ONS 15540
physical PM data.
physical PM data.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS155XX_PHY_PM_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-193: ONS155xx_Phy_PM_Table