Isabelle DASTUGUE <[email protected]> writes: > Hello, > I have a database which is currently 272 MB If I created a second with > the same structure and the same data is important, it does more than > 2MB > I attempted to reduce the first with: > CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE (), > CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE (1), > CALL and SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE > (?, 1) > But that changes nothing. > Is there something else to do?
Hi Isabelle, The following chapter in the Derby Server and Administration Guide explains why tables and indexes may take more disk space than expected, and how to reclaim the unused space: https://db.apache.org/derby/docs/10.9/adminguide/cadminspace21579.html Hope this helps, -- Knut Anders
