---In [email protected], <maciejlik@...> wrote :
 ...
 > Before making repair the database checked the database are logged 2 users 
 > SYSDBA (server and client). In this case, 
> the command gfix not block access to the database - not disconnect the user 
> SYSDBA client. ...

 > What command to use before taking any remedial action on the database 
 > Firebird to disconnect a user SYSDBA (client)?

  Read 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113
 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113
carefully and choose what you really need. For example, you may want to get of  
all users from db (including SYSDBA):
gfix -shut full -force 0

...then allow single attachment...
 gfix -online single
 

 ...to validate database...
 gfix -v -full
 

 ...and finally bring database online for all users


gfix -online 

  
Hope it helps,
Vlad



Reply via email to