gfix(1) Firebird database maintenance tool


gfix option... database


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


Common options

-user username
-pa[ssword] password
User name and password for connecting to Firebird.
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 full or reserve space for versions.
-w[rite] "sync"|"async"
Switchd database to synchronous or asynchronous write mode.

Database sweep (garbage collection)

Perform immediate garbage collection.

Shadow file maintenance

Acivate shadow file for database usage
Kill all unavailable shadow files.


Turn on validation mode
Validate record fragments.
-i[gnore] Ignore checksum errors.
Perform read-only validation, without writing any corrections.
Show limbo transactions.
-c[ommit] ID|"all"
Commit transaction ID (or all).
-r[ollback] ID|"all"
Rollback transaction numver ID (or all).
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).
Prepare corrupt database for backup.

Database shutdown

Shutdown database.
Prevent new database attachments.
Prevent starting of new transactions.
Force database shutdown.
Bring the database online (the opposite of shutdown).
Shutdown cache manager.


Copyright (c) 2015 Damyan Ivanov <[email protected]>.

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.