Subject Re: [ib-support] Re: force disconnect users
Author Helen Borrie
At 04:38 AM 24-07-02 +0000, Andrew Ferguson wrote:

>If you are determined to shutdown the db and deny access then simply:
>gfix -shut -force n (n being time to wait til forced shutdown)
>see also gfix -shut -tran n, gfix -shut -attach n
>Do your gbak, or whatever, confident that there are no connections
>(nobody but owner and sysdba can access the db) then bring it back up
>gfix -online

You can only be confident that you have exclusive access if there is no
chance that you are not the only (human) user who has owner or sysdba
rights. If, for example (and I seem to recall it was the case with Fred's
deployment), many or all users log in as sysdba or owner, then there is no
way to know or guarantee that one of those "other sysdbas" who were already
logged in when you did the forced shutdown are locked out. They can just
keep on chugging away - database integrity be damned.


All for Open and Open for All
Firebird Open SQL Database · ·