Tech Tip: Where are the alarms stored in UIM?

Document created by Marco_Ippati Employee on Apr 18, 2018Last modified by Marco_Ippati Employee on Apr 18, 2018
Version 2Show Document
  • View in full screen mode

Where are the alarms stored in UIM?

 

Question:
Where are the alarms stored in UIM?
Where the alarms showing in USM and IM stored?
Environment:
UIM 8.x
Answer:
Infrastructure Manager (IM) Alarm Subconsole

User-added image


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

User-added image


The alarms showing in the USM 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 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:
1 person found this helpful

Attachments

    Outcomes