Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space
Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space.
Basically, is there some utility or CLI command that would allow us to estimate if it is worth the effort of compacting a large database or not.
Thanks
Hello James,
This documentation should contain the answers you seek: Displaying Free Space Information.
You can use the System Management Portal's Databases page, or ^%FREECNT.
Hope that helps!