Subject | Re: [firebird-support] Restart Database |
---|---|
Author | Martijn Tonies |
Post date | 2003-11-27T09:47:27Z |
Hi,
logins and/or transaction and forces people to disconnect. After this,
the database is in - almost - single user mode, only the db owner and
SYSDBA can connect. This is useful for maintenance, like validation,
or adding foreign key constraints or other metadata operations.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> I'm using IBConsole as GUI for my firebird database. There is an option ofrestarting the database when we right click the database.
> Can someone tell what this actually means?It's the reverse of "shutdown". A "shutdown database" disables new
logins and/or transaction and forces people to disconnect. After this,
the database is in - almost - single user mode, only the db owner and
SYSDBA can connect. This is useful for maintenance, like validation,
or adding foreign key constraints or other metadata operations.
> How this can be accomplished through command line?Via "gfix".
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com