Firebird Documentation Index → Gfix - Database Housekeeping
Firebird Home Firebird Home Firebird Documentation IndexNext: Command Line Options

Firebird Database Housekeeping Utility

Norman Dunbar

09 April 2013 – Document version 1.4


Table of Contents

Introduction
Command Line Options
Gfix Commands
Shadow Files
Set Database Page Buffers
Limbo Transaction Management
Cache Manager
Changing The Database Mode
Setting The Database Dialect
Database Housekeeping And Garbage Collection
Database Startup and Shutdown
Database Page Space Utilisation
Database Validation and Recovery
Database Write Mode
Version Number
Caveats
A. Document history
B. License notice

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 ...

Firebird Documentation IndexNext: Command Line Options
Firebird Documentation Index → Gfix - Database Housekeeping