How to reduce the size of the DX UIM nas's internal databases
Article ID: 10006
Updated On:
Products
Issue/Introduction
Sometimes the nas internal database files can increase in size due to alarm floods. We can use the nas Reorganize Database feature to reclaim disk space.
The nas reorganize database command will run a vacuum against the internal databases. This will free up some of the disk that is being used.
Note, this assumes that the database.db and transactionlog.db have empty pages to free. If however, you have tens of thousands of alarms you will not see much, if any, reduction in size.
You can reduce the number of rows in the transaction log by modifying a few settings in the nas GUI. This would be under the Setup -> Transaction Log Tab.
The settings with the most impact will be "Keep Transaction History" and "Keep transaction summary"
These refer to the NAS_TRANSACTION_LOG and NAS_TRANSACTION_SUMMARY tables that are internal to the transactionlog.db file.
They both affect the amount of time and information you are able to see in alarm history from within the Infrastructure Manager.
Environment
- Release: UIM 8.x, 9.x
- Component: nas any supported version
Cause
- Sometimes the nas local database files can increase in size due to alarm floods.
Resolution
- Open the NAS configuration GUI in the Infrastructure Manager
- Click the Status tab
- Right-Click the window pane containing alarm messages inside the nas GUI
- Select Advanced -> Reorganize Database
- You will see this in the nas log
- Feb 14 13:37:34:799 [3088] nas: =====[ DATABASE REORGANIZE requested by Administrator from xx.xx.xxx.xxx/60657
- The alarm enrichment and nas probes will stop processing alarms for a bit of time while the database is being reorganized. They will restart once completed.
Additional Information
Please refer to the following KB Articles for more detailed information:
Feedback
