At 11:43 AM 5/28/2004, triptomik wrote:

> My question is, why doesn't firebird
>use exclusive file locking when it first opens the filehandle for the
>database file in a similar fashion?

If you're running classic, then each client is accessing the database
directly, so the file is shared. The SuperServer locks the file for
write, but allows readers so that the statistics utility can run against
an active database.

>I'm assuming that the database files CAN be file copied while the
>Firebird service is not running, correct?

Yes.

>Would there be a simple way to
>convert our databases to FireBird or just simply change the forced
>writes parameter?

If you've got InterBase 6 databases, then Firebird 1.0x runs fine with
them. Just install it. Or use gfix to set forced writes on in InterBase.

> And if so, does this typically solve the problem
>with the power down scenario?

Yes.


Regards,


Ann