How to reduce the size of the DX UIM nas's internal databases
search cancel

How to reduce the size of the DX UIM nas's internal databases


Article ID: 10006


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


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.


  • Release: UIM 8.x, 9.x
  • Component: nas any supported version


  • Sometimes the nas local  database files can increase in size due to alarm floods.


  1. Open the NAS configuration GUI in the Infrastructure Manager
  2. Click the Status tab
  3. Right-Click the window pane containing alarm messages inside the nas GUI
  4. Select Advanced -> Reorganize Database
  5. You will see this in the  nas log
    1. Feb 14 13:37:34:799 [3088] nas: =====[ DATABASE REORGANIZE requested by Administrator from
    2. 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:

nas Transaction Logging/Transaction Summary and compression

nas (Alarm Server) Release Notes