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 …