db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Embedded Derby and .dat files
Date Mon, 22 Sep 2008 12:58:04 GMT
Fuzzo <mcuccato@gmail.com> writes:

> Hi all!
>
> I looked for stange options in configuration but the only one regarding
> Derby is:
> derby.storage.fileSyncTransactionLog=true
>
> I think this doesn't modify default 10MB log limit for checkpoint.

I think you're right.

Just to make sure that you don't have log archiving mode enabled, you
could issue this statement:

  CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1)

> From friday to now, the log directory size is 2.5GB: if i can't force derby
> to checkpoint, i'll switch to another db... :(

You can force Derby to checkpoint by issuing

  CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()

-- 
Knut Anders

Mime
View raw message