Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space

Primary tabs

Databases, Caché

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

  • 0
  • 0
  • 63
  • 0
  • 1

Answers

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!