gfix -- miscelenous Firebird database maintenance
is a program that allows the Firebird administrator or database
owner to perform various maintenance tasks.
- Activate database shadow file.
- -b number
- -buffers number
- Set database buffer size, in pages.
- -co number|"all"
- -commit number|"all"
- Commit a limbo transaction with a given number or all limbo
- -h number
- -housekeeping number
- Set the housekeeping interval. When the difference between
the oldest interesting transaction and the current transaction exceeds
number, an automatic garbage collection (sweep) process is started
to make possible increasing of the oldest interesting transaction number.
When number is 0, there is no automatic sweep and OIT advancement
should be arranged by other means, e.g. gfix -sweep via
- Fix the database to be usable with the available ICU
Some collations in Firebird are bound the the version of the ICU library.
When such a collation needs to be used in an environment with a different
version of ICU, an error occurs. gfix -icu is the remedy.
- Kill unavailable database shadow files.
- List limbo transactions.
- Prompt for commit/rollback for each transaction in
- Prepare corrupt database for backup.
- -mo access
- -mode access
- Set database access mode. Possibla values are
"read_only" and "read_write".
- Temporary remove linger setting of the database.
Similar to the following SQL statement:
alter database drop linger;
but the next attachment to the database will restore the linger setting.
- -o [mode]
- -online [mode]
- Brings the database online. The reverse of -shut.
mode can be:
- This is the default. Brings the database fully online, all
normal connections are permitted.
- Permits multiple connections from SYSDBA and the database
- Permins only one connection from SYSDBA or the database
- Perform database validation.
- Full validation. Record fragments are verified.
- Ignore record checksum errors.
- Peform read-only validation.
- -r number|"all"
- -rollback number|"all"
- Rollback given limbo transaction or all limbo
- -sq number
- -sql_dialect number
- Change the SQL dialect of the database.
- Perform immediate garbage collection on the database.
- -sh [mode] option timeout
- -shutdown [mode] option
- Shuts the database down. mode is either of
- Multiple connections from SYSDBA and the database owner are
allowed. Ordinary osers are denied any requests to the database. This is
the default mode.
- Only a single connection from SYSDBA or the database owner
- No connections to the database are allowed.
- Ignored. Equivalent to -multi.
is either of
- Prevents new attachments (connections). Active connections
continue to work.
- Prevents new transactions. Open transactions continue to
- Force immediate database shutdown. All running statements,
transactions and connections are aborted.
- Perform two-phase recovery of limbo transactions.
- -u mode
- -use mode
- Set the page allocation preference. When mode is
"reserve" a certain amount of the page is kept aside for record
versions. When mode is "full" database pages are used
fully without such reservarions.
Corresponds to the -use_all option of gbak(1).
- -w mode
- -write mode
- Sets the synchronous writes flag. "sync" sets the
synchronous mode flag (also known as "forced writes").
"async" clears the flag.
When the flag is on, all writes to the database are synchronised via a call
to the operating system to ensure that the data has reached stable
- -fe file
- -fetch_password file
- Read password from file.
- -pas string
- -password string
- Password for the connection.
- -ro string
- -role string
- Use supplied SQL role for the connection.
- -user string
- Use supplied user name for the connection.
- Prints the gfix version number before anything
- Default value for the -user option.
- Default value for the -role option.
- Default value for the -password option.
Additional documentation about Firebird can be found on the Firebird Project
This manual page was written by Damyan Ivanov email@example.com for the Debian
project. 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.