ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA UIM - Nimsoft SLM Database Growth - NAS_TRANSACTION_LOG table


Article ID: 102927


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) NIMSOFT PROBES


Our database has grown significantly and our DBA has spotted that data in the NAS Transaction Log (NAS_TRANSACTION_LOG table) does not seem to be being trimmed according to the rules set in the Data_Engine. Assuming we don't want the data is it safe for the DBA to remove, 2015 -2017 data?? 



Component: UIMDEG


In this situation no changes are required to the data_engine settings. The NAS_TRANSACTION_LOG table is managed by the NIS BRIDGE settings. These tables are maintained by the nas using the NiS bridge configuration data. To keep the size of these tables in the NiS database manageable, they are automatically compressed at the configured administration interval, see the following documentation for more details: 

The NiS Bridge Tab -  

We've seen previously if the volume of data is large and the maintenance job cannot complete within the scheduled time frame, it will cancel the maintenance job and not delete any data. That could be the case here, if you manually delete the unwanted data from the NAS_TRANSACTION_LOG we would recommend taking a backup of the UIM database or table prior to removing the data (if possible) and stopping (deactivating) the data_engine and nas probes.

Additional Information

Regarding data_engine retention settings I would advise reviewing the following articles and best practices: 

data_engine best practices - 

How does data_engine handle retention? - 

How does data_engine maintenance and retention work? -