sourCEntral - mobile manpages

pdf

GFIX

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 AT sente DOT 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.

pdf