Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
23
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
AckTimeStamp
DATE
—
Date and time of the acknowledgement.
IsAutoAck
NUMBER(1)
—
Whether acknowledgment is manual or
automatic:
0: Manual
1: Automatic
automatic:
0: Manual
1: Automatic
1.1.2 Active_Alarm_Table
The Active_Alarm_Table contains information about all standing conditions on NEs.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ACTIVE_ALARM_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-2: Active_Alarm_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.
NEDBAccessID in the NE_INFO_TABLE.
AlarmSeqNum
NUMBER(20)
NOT NULL
Unique sequence number of the alarm as
referenced by the NE.
referenced by the NE.
ModuleOrIfInd
ex
ex
NUMBER(20)
NOT NULL
Unique long data type that identifies an
interface in the NE; same as ifStaticIndex
in the Interface_Table.
interface in the NE; same as ifStaticIndex
in the Interface_Table.
ActiveAlarmTi
meStamp
meStamp
DATE
NOT NULL
Date and time when the active alarm was
generated.
generated.
ActiveAlarmTy
pe
pe
NUMBER(5)
NOT NULL
Alarm event type. Values are rows of the
Alarm_Event_Type_Enum_Table.
Alarm_Event_Type_Enum_Table.
ActiveAlarmSe
verity
verity
NUMBER(1)
NOT NULL
Severity level of the alarm. Values are:
3: Not alarmed
4: Warning
5: Minor
6: Major
7: Critical
3: Not alarmed
4: Warning
5: Minor
6: Major
7: Critical
ActiveAlarmSer
vEff
vEff
NUMBER(1)
NOT NULL
Values are:
0: Alarm does not affect service
1: Alarm affects service
2: Unknown
0: Alarm does not affect service
1: Alarm affects service
2: Unknown
ActiveAlarmAd
ditionalInfo
ditionalInfo
VARCHAR2(512
)
)
—
Additional information about the current
alarm.
alarm.