NAME

       gfix — GFIX - Firebird command-line tool

DESCRIPTION

       gfix  is  a  tool  whitch  performs  a  number of maintenance activities on a database eg.
       database shutdown, making minor data repairs.

       http://www.firebirdsql.org/ - Documentation ->  Knowledgebase  ->  User  Documentation  ->
       Interbase 6. Operation Guide.

COMMON OPTIONS

   -activate
       Acivate shadow file for database usage

   -at[tach] n
       shutdown new database attachments

   -b[uffers] n
       Set page buffers n

   -c[ommit] {ID|all}
       Commit transaction (tr / all)

   -ca[che] n
       Shutdown cache manager

   -f[ull]
       Validate record fragments (-v)

   -f[orce] n
       Force database shutdown

   -h[ousekeeping] n
       Set sweep interval (n)

   -i[gnore]
       Ignore checksum errors

   -kill
       Kill all unavailable shadow files

   -l[ist]
       Show limbo transactions

   -m[end]
       Prepare corrupt database for backup

   -m[ode] [read_write|read_only]
       read-only or read-wrire

   n[o_update]
       read-only validation (-v)

   -o[nline]
       Database online

   -pa[ssword] password
       Default password

   -p[rompt]
       Prompt for commit/rollback (-v)

   -r[ollback] {ID|all}
       Rollback transaction (tr / all)

   -s[ql_dialect] n
       Set database dialect n

   -s[weep]
       Force garbage collection

   -sh[ut]
       Shutdown database

   -t[wo-phase] {ID|all}
       Perform automated two-phase recovery

   -tr[an] n
       Shutdown transaction startup

   -use
       Use full or reserve space for versions

   -user name
       Default user name

   -v[alidate]
       Validate database structure

   -w[rite] {sync|async}
       Write synchronously or asynchronously

   -z
       Print software version number

EXAMPLES

AUTHOR

       This manpage was written by Daniel Urban <daniel@sente.pl> for Debian GNU/Linux but may be
       used by others.

COPYRIGHT

       Permission is granted to modify and distribute this manpage under the terms of GNU General
       Public  Licence  version  2 or (at your oppinion) any later version. It is provided in the
       hope that it will be useful but with NO  WARRANTY.  Author  is  not  responsible  for  any
       (mis)use of this manpage.

                                                                                          GFIX(1)