-ac-activate_shadow
Activate database shadow file.
-bnumber-buffersnumber
Set database buffer size, in pages.
-conumber|"all"
-commitnumber|"all"
Commit a limbo transaction with a given number or all limbo transactions.
-hnumber-housekeepingnumber
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 cron(1).
-icu
Fix the database to be usable with the available ICU version.
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.
-k-kill_shadow
Kill unavailable database shadow files.
-l-list
List limbo transactions.
-pr-prompt
Prompt for commit/rollback for each transaction in limbo.
-me-mend
Prepare corrupt database for backup.
-moaccess-modeaccess
Set database access mode. Possibla values are "read_only" and "read_write".
-nol-nolinger
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.
See sql.extensions/README.linger.
-o [mode]
-online [mode]
Brings the database online. The reverse of -shut.
mode can be:
normal
This is the default. Brings the database fully online, all normal connections are permitted.
multi
Permits multiple connections from SYSDBA and the database owner.
single
Permins only one connection from SYSDBA or the database owner.
-v-validate
Perform database validation.
Validation options:
-fu-full
Full validation. Record fragments are verified.
-i-ignore
Ignore record checksum errors.
-n-no_update
Peform read-only validation.
-rnumber|"all"
-rollbacknumber|"all"
Rollback given limbo transaction or all limbo transactions.
-sqnumber-sql_dialectnumber
Change the SQL dialect of the database.
-sw-sweep
Perform immediate garbage collection on the database.
-sh [mode] optiontimeout-shutdown [mode] optiontimeout
Shuts the database down. mode is either of
multi
Multiple connections from SYSDBA and the database owner are allowed. Ordinary osers are denied
any requests to the database. This is the default mode.
single
Only a single connection from SYSDBA or the database owner is allowed.
full
No connections to the database are allowed.
-ca-cache
Ignored. Equivalent to -multi.
option is either of
-at-attach
Prevents new attachments (connections). Active connections continue to work.
-tra-transaction
Prevents new transactions. Open transactions continue to work.
-fo-force_shutdown
Force immediate database shutdown. All running statements, transactions and connections are
aborted.
-tw-two_phase
Perform two-phase recovery of limbo transactions.
-umode-usemode
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).
-wmode-writemode
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 storage.
Install Now
PNG Icons