This is the command gfix that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator
PROGRAM:
NAME
gfix — GFIX - Firebird command-line tool
DESCRIPTION
gfix is a tool whitch performs a number of maintenance activities on a database eg.
database shutdown, making minor data repairs.
http://www.firebirdsql.org/ - Documentation -> Knowledgebase -> User Documentation ->
Interbase 6. Operation Guide.
COMMON OPTIONS
-activate
Acivate shadow file for database usage
-at[tach] n
shutdown new database attachments
-b[uffers] n
Set page buffers n
-c[ommit] {ID|all}
Commit transaction (tr / all)
-ca[che] n
Shutdown cache manager
-f[ull]
Validate record fragments (-v)
-f[orce] n
Force database shutdown
-h[ousekeeping] n
Set sweep interval (n)
-i[gnore]
Ignore checksum errors
-kill
Kill all unavailable shadow files
-l[ist]
Show limbo transactions
-m[end]
Prepare corrupt database for backup
-m[ode] [read_write|read_only]
read-only or read-wrire
n[o_update]
read-only validation (-v)
-o[nline]
Database online
-pa[ssword] password
Default password
-p[rompt]
Prompt for commit/rollback (-v)
-r[ollback] {ID|all}
Rollback transaction (tr / all)
-s[ql_dialect] n
Set database dialect n
-s[weep]
Force garbage collection
-sh[ut]
Shutdown database
-t[wo-phase] {ID|all}
Perform automated two-phase recovery
-tr[an] n
Shutdown transaction startup
-use
Use full or reserve space for versions
-user name
Default user name
-v[alidate]
Validate database structure
-w[rite] {sync|async}
Write synchronously or asynchronously
-z
Print software version number
EXAMPLES
Use gfix online using onworks.net services