Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
86
1.1.69 L2_Ipsla_Table
The L2_Ipsla_Table contains information about the IP SLAs that were created for a
specific Layer 2 service.
specific Layer 2 service.
Primary key: IPSLA_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-67: L2_Ipsla_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
TopoNodeID
NUMBER(10)
NOT NULL
Node ID of the circuit's source node.
TopoUniqueId
NUMBER(10)
NOT NULL
Unique number within the node.
Vlan_Number
NUMBER(10)
NOT NULL
Unique number to identify the VLAN.
Ipsla_Number
NUMBER(10)
NOT NULL
Unique number to identify the IP SLA.
Destination_NeId
NUMBER(10)
—
ID of the destination NE.
Destination_PhyLoc
NUMBER(20)
—
Destination physical location.
Destination_Addr
VARCHAR2(50) —
Destination IP address.
Source_NeId
NUMBER(10)
—
Source NE ID.
Source_PhyLoc
NUMBER(20)
—
Source physical location.
Source_Addr
VARCHAR2(50) —
Source IP address.
Operation_Type
VARCHAR2(50) —
Operation type. The possible values
are:
jitter: JITTER
echo: ECHO
are:
jitter: JITTER
echo: ECHO
Operation_status
NUMBER(10)
—
Operation status. The possible values
are:
0: NOT_SCHEDULED
1: SCHEDULED_RUNNING
2: SCHEDULED_NOT_RUNNING
are:
0: NOT_SCHEDULED
1: SCHEDULED_RUNNING
2: SCHEDULED_NOT_RUNNING
1.1.70 L2QoSTemplate_QoSClass_Table
The L2QoSTemplate_QoSClass_Table is used to store all the Quality of Service (QoS)
parameters defined in a QoS profile. QoS profiles are used during Layer 2 services
creation to specify the QoS parameters for the service drops.
parameters defined in a QoS profile. QoS profiles are used during Layer 2 services
creation to specify the QoS parameters for the service drops.
Primary key: None