Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Education
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
DX Infrastructure Management
Private Community
Community Home
Threads
Library
Events
Members
Back to Library
Tech Tip: Where are the alarms stored in UIM?
0
Recommend
Apr 18, 2018 11:53 AM
Marco Ippati
Where are the alarms stored in UIM?
KB000091897
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
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
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:
Related Articles:
What do the time related fields mean in the Alarm Tables in UIM?
nas Transaction Logging/Transaction Summary and compression
Nas alarm counts are not in sync between UMP USM and the Infrastructure Manager alarm subconsole
Nas (alarm server) documentation
Statistics
0 Favorited
11 Views
0 Files
0 Shares
0 Downloads
Related Entries and Links
No Related Resource entered.
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic