man gfix (1): Firebird database maintenance tool

SYNOPSIS

gfix option... database

DESCRIPTION

gfix is a tool whitch performs a number of maintenance activities on a database eg. database shutdown and making minor data repairs.

OPTIONS

Common options

-user username
-pa[ssword] password: User name and password for connecting to Firebird.
-z: Print software version number.

Database parameters

-b[uffers] n: Set page buffers to n pages.
-h[ousekeeping] n: Set sweep interval to n transactions.
-s[ql_dialect] n: Set database dialect to n.
-m[ode] "read_write|read_only": Switch database to read/write or read-only mode.
-use: Use full or reserve space for versions.
-w[rite] "sync"|"async": Switchd database to synchronous or asynchronous write mode.

Database sweep (garbage collection)

-s[weep]: Perform immediate garbage collection.

Shadow file maintenance

-activate: Acivate shadow file for database usage
-kill: Kill all unavailable shadow files.

Validation

-v[alidate]: Turn on validation mode
-f[ull]: Validate record fragments.
-i[gnore] Ignore checksum errors.
-n[o_update]: Perform read-only validation, without writing any corrections.
-l[ist]: Show limbo transactions.
-c[ommit] ID|"all": Commit transaction ID (or all).
-r[ollback] ID|"all": Rollback transaction numver ID (or all).
-p[rompt: Prompt for commit/rollback for each transaction that is in limbo.
-t[wo-phase] ID|"all": Perform automated two-phase recovery for transaction ID (or all).
-m[end]: Prepare corrupt database for backup.

Database shutdown

-sh[ut]: Shutdown database.
-at[tach]: Prevent new database attachments.
-tr[an]: Prevent starting of new transactions.
-f[orce]: Force database shutdown.
-o[nline]: Bring the database online (the opposite of shutdown).
-ca[che]: Shutdown cache manager.

AUTHOR AND LICENSE

Permission is granted to use this document, with or without modifications, provided that this notice is retained. If we meet some day, and you think this stuff is worth it, you can buy me a beer in return.