clean out all of alarms from UIM system

Document ID : KB000124367
Last Modified Date : 04/03/2019
Show Technical Document Details
Issue:
I would like to clean out all of my alarms from UIM system. I do not care about the alarms any longer and want to bring the alarm database content back to a zero state.
Resolution:
- Deactivate nas probe
- Issue the following queries in this order one at a time using the SLM portlet (recommended) in UMP or SQL Management Studio / SQL Workbench / database query tool of choice:
 
TRUNCATE TABLE NAS_ALARMS;
TRUNCATE TABLE NAS_TRANSACTION_SUMMARY;
TRUNCATE TABLE NAS_TRANSACTION_LOG;

- Rename the following in the nas probe directory:
 
database.db
isQueue.db
transactionlog.db

- Activate nas probe