search cancel

can we just drop the nas_transaction log table?


Article ID: 189304


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


Can  I just drop nas_transaction_log table in our production environment as it is consuming 642 GB? Plan is as below.

1) deactivate NAS probe

2) run the query "DROP TABLE NAS_TRANSACTION_LOG" to drop the table.

3)Activate NAS probe

By performing the above activity, i expect only the transaction history of the alarms will be lost and there will be no duplicate alerts and does not affect the active alarms. Can you please confirm this.

name rows reserved data index_size unused

NAS_TRANSACTION_LOG 457324444            691591576 KB 646221392 KB 45250144 KB 120040 KB


Release : 9.1.0

Component : NAS


- nas table administration


Do not drop only the nas_transaction_log table as that could cause problems. Instead you could either run a delete statement and delete rows from that table based on a given date or TRUNCATE the table, but here is a more solid and potentially permanent approach for you to consider which enables the nas housekeeping to complete its run and in turn minimizes the size of that table over time.

NAS_TRANSACTION_LOG table growing indefinitely