Subject Determine total pre-allocated space
Author Bryan Cole

I need to be able to detect when the total available space for a firebird database is running low. When this happens I need to warn users to purge old data. However, deleting data does not free up disk space. This in itself is fine, but how can I measure the resulting free space in the database after deleting many records from a table?

What I want is total space available being the sum of available (unallocated) disk space + free pre-allocated space. Measuring unallocated disk space is easy but I've no idea how to measure the pre-allocated space.


Bryan Cole