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
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.