Tuesday, April 12, 2011

Firebird server (Fbserver) command line switches

Following table contains most common Firebird server command line switches.

-a run as application. Applicable only if Firebird runs as application.
-n no icon in the system tray. Applicable if Firebird runs as application.
-b run with high (boosted) priority.
-r run with normal priority. This is default priority.
-p specify port number/name or named pipe.
-i accept tcp/ip connections.
-l accept local connections
-w accept NETBEUI connections.

Reference - http://www.volny.cz/iprenosil/interbase/fbserver_switches.htm

Tuesday, April 05, 2011

How to use gfix on Windows

gfix -user SYSDBA -password masterkey localhost:C:\MyDatabase.fdb -v -f

gfix is Firebird’s command line tool for administration issues like data repair, sweeping etc. Above is the syntax for how to use this tool on a Windows machine.

  • gfix.exe is located in your Firebird installation directory.

  • -v option in the above example specifies that we want to validate the database.

  • -f options means full to mean all records and pages and release unassigned record fragments.

  • localhost specifies that database is located on this machine only.

Following page has details of all the options that can be used with gfix.