Codex

GFIX

Section: User Commands (1)

Index?action=index Return to Main Contents


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 <[email protected]> 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.


Index

NAME

DESCRIPTION

COMMON OPTIONS

-activate

-at[tach] n

-b[uffers] n

-c[ommit] {ID|all}

-ca[che] n

-f[ull]

-f[orce] n

-h[ousekeeping] n

-i[gnore]

-kill

-l[ist]

-m[end]

-m[ode] [read_write|read_only]

n[o_update]

-o[nline]

-pa[ssword] password

-p[rompt]

-r[ollback] {ID|all}

-s[ql_dialect] n

-s[weep]

-sh[ut]

-t[wo-phase] {ID|all}

-tr[an] n

-use

-user name

-v[alidate]

-w[rite] {sync|async}

-z

EXAMPLES

AUTHOR

COPYRIGHT


More Man Pages