db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Database Size
Date Tue, 19 Mar 2013 13:33:33 GMT
Isabelle DASTUGUE <isabelle.dastugue@sela-light.com> 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

Mime
View raw message