gfix (1)

Contents

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

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.