Hello,
I work on software that uses the engine Firebird 2.1.5. The software runs on the network as a server-client. In both cases, the firebird software logs on to the database as a user SYSDBA. When repairing a damaged database, one of the steps is "block access to the database"
I use: gfix damaged.fdb -shut -force 240 -user SYSDBA -password masterkey
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.
Recommendation:
isql c: \ Progra ~ 1 \ Novitus \ Soga \ Database \ gastro.fdb -user SYSDBA -password masterkey
show users;
// Shows 2 registered users SYSDBA
What command to use before taking any remedial action on the database Firebird to disconnect a user SYSDBA (client)?
Regards,
Maciej Lik
__._,_.___
Posted by: "maciejlik@gmail.com" <maciejlik@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment