Where are the alarms stored in UIM?

book

Article ID: 91897

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

Where are the alarms stored in UIM?
Where are the alarms showing in USM/Operator Console alarm viewer and IM stored?

Environment

UIM 8.x, 9.x, 20.x, 20.3.x

Resolution

Infrastructure Manager (IM) Alarm Subconsole

 



The alarms that show in IM are stored in 2 SQLlite db files named database.db and transactionlog.db located in the nas folder  \Nimsoft\probes\service\nas.

 

•  The database.db contains all active alarms (All alarms that are open and that are visible in the IM Subconsole)

Tables In the database.db

NAS_ALARMS

Stores all open alarms. All alarms in this table are visible in IM (and USM)

 

NAS_ALARM_ATTACHMENT

NAS_ALARM_NOTE

NAS_NAME_SERVICE

NAS_NOTES



•  The transactionlog.db contains the transaction history and transaction log of open and closed (aknowledged) alarms.

 

NAS_TRANSACTION_SUMMARY

Stores a unique entry (identifier: nimid) for all alarms (open and closed). When an alarm is acknowledged it is removed from the NAS_ALARMS table and at the same time the "closed" field of the NAS_TRANSACTION_SUMMARY populates with the date and time the alarm was acknowledged.

 

NAS_TRANSACTION_LOG

Stores every single occurrence of the same alarm (Same nimid)

 

NAS_ACTIVITY_LOG

NAS_VERSION






Unified Service Manager (USM) Alarm View (<UIM 20.1)


 

Operator Console alarm viewer (UIM 20.3 and later)

 

 

The alarms showing in the USM/OC alarm view are retreived from the UIM DB. The nas nis-bridge, (enabled by default), generates an exact replica of the tables contained in the database.db and the transactionlog.db.

The nis-bridge keeps the SQLlite db alarm tables in synch with the UIM DB alarm tables, bidirectionally. 

The UIM DB contain the same alarm tables contained in the database.db and transactionlog.db.

 

Although all tables are kept in synch, the nas_transaction_log and nas_transaction_summary in the 2 databases might contain a different amount of entries.

This is because the transaction logging and compression configuration (eg. how long the transaction history is stored fo) for the 2 databases are managed separately: in The Transaction Log Tab and in The NiS Bridge Tab.

 

The IM and the USM/OC should show the same amount of open alarms, meaning that the 2 NAS_ALARMS Tables in both databases should be in synch.

If they are not check this KB

Additional Information

Related Articles:

Where are the alarms stored in UIM?

What do the time related fields mean in the Alarm Tables in UIM?

nas Transaction Logging/Transaction Summary and compression

What is the meaning of the of nas alarm Subjects?

Where is the NAS address table data stored?


Nas alarm counts are not in sync between UMP USM and the Infrastructure Manager alarm subconsole

Why do some alarms' "count" increase immediately in the alarm console while others don't show the count increasing even when the alarms are suppressed?

Nas (alarm server) documentation

Attachments