Search code examples
intersystems-iris

How to shrink IRISTEMP db in runtime?


After running an extensive block of daily statistics my IRISTEMP
has expanded dramatically. But FreeSpace shows 97% unused and FREE space. How can I shrink IRISTEMP in runtime without shutdown and manual intervention?


Solution

  • What do you mean 'without manual intervention' ? You can shrink it with the database tools (Do ^DATABASE, option 13 (compact free space in a database) & option 12 (return free space for a database). But that is a 'manual' intervention. It will only happen automatically when you restart Iris.