gfix — GFIX − Firebird command-line tool
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.
−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
This manpage was written by Daniel Urban <daniel AT sente DOT pl> for Debian GNU/Linux but may be used by others.
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.