Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
27
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
criteria.
criteria.
1.1.5 Alarm_Ack_Config_Table
The Alarm_Ack_Config_Table stores information about whether or not automatic alarm
acknowledgement is enabled.
acknowledgement is enabled.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-5: Alarm_Ack_Config_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
ConfigAlarmAck
NUMBER(1)
NOT NULL
A global, C-style, Boolean variable that
represents whether alarm
acknowledgement is on for all alarms.
Values are:
0: Automatic Acknowledge
1: Manual Acknowledge
represents whether alarm
acknowledgement is on for all alarms.
Values are:
0: Automatic Acknowledge
1: Manual Acknowledge
1.1.6 Alarm_Count_Table
The Alarm_Count_Table stores the alarm count for each level of severity for every NE.
Primary key: ALARM_COUNT_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-6: Alarm_Count_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
nedbaccessid
NUMBER(10)
NOT NULL
ID to access this table for an NE; same
as NEDBAccessID in the
NE_INFO_TABLE.
as NEDBAccessID in the
NE_INFO_TABLE.
ackalarmcount
NUMBER(20)
DEFAULT 0
Acknowledged alarm count.
clearedalarmcount
NUMBER(20)
DEFAULT 0
Cleared alarm count.
minoralarmcount
NUMBER(20)
DEFAULT 0
Minor alarm count.