Written by

Question James Hipp · Oct 7, 2019

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

#Caché #Databases

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

Discussion (1)0

Vic Sun · Oct 8, 2019

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!

0 0