Introduction
<< | Firebird Database Housekeeping Utility | >>
Introduction
gfix
allows attempts to fix corrupted databases, starting and stopping of databases, resolving 'in limbo' transactions between multiple databases, changing the number of page buffers and so on. gfix
is a general purpose tool for system administrators (and database owners) to use to make various 'system level' changes to their databases.
Almost all the gfix
commands have the same format when typed on the command line:
gfix [commands and parameters] database_name
The commands and their options are described in the following sections. The database name is the name of the primary database file which for a single file database is simply the database name and for multi-file databases, it is the first data file added.
Coming up in the remainder of this manual, we will discuss the following:
- Command-line options for the
gfix
database utility. - Shadow file handling.
- Cache and buffer handling.
- Transaction management.
- Cache management.
- Starting and stopping a database.
- And much, much more ...
See also:
Database validation
Database repair
How to analyse and repair a corrupted database
Backup database
Restore database
Database corruption
GFIX
GBAK
and GSPLIT
Forced writes
Firebird for the database expert: Episode 3 - On Disk Consistency
Preventing data loss
Alternative database repair methods
Detect and avoid database errors
Tracking down crashes on Win32 systems
Tracking down crashes on Linux
back to top of page
<< | Firebird Database Housekeeping Utility | >>