Subject Re: [ib-support] Gfix usage
Author Paul Reeves
A6-CMO Philippe Makowski wrote:

> In fact I want a procedure to be certain that I am the only one connected to
> the database

There is no reliable and consistent way to achieve this at the moment.
The 'hack' is to try and rename the database file. If you can do that
then no-one is connected and you can then connect to the newly named
database and carry out whatever maintenance work is required.

The problem is that renaming a database will require some kind of access
to the file system that the database is stored on. This may not always
be possible.

I guess the proper solution to this is to ensure that when a database is
shutdown that only a single connection from either the owner or sysdba
is allowed. However, at the moment, multiple connections are allowed.


Paul Reeves
Supporting users of Firebird and InterBase