. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3. Gfix Commands. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Table of Contents 2 Chapter 1. Introduction Gfix allows attempts to fix corrupted databases, starting and stopping of databases, resolving 'in limbo' 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

exist 100 335544374 stream_eof Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure gbak_unknown_switch Found unknown switch -901 336920577 gstat_unknown_switch Found unknown switch -901 335740929 gfix_db_name Data base file name (%s) already given -901 335544322 bad_dbkey Invalid database key -901 a database name -901 336330754 gbak_page_size_missing Page size parameter missing -901 335740930 gfix_invalid_sw Invalid switch %s -901 336920579 gstat_wrong_ods Wrong ODS version, expected %d, encountered

exist 100 335544374 stream_eof Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format Unsigned short integer expected -842 335544712 expec_positive Positive value expected -901 335740929 gfix_db_name Data base file name (@1) already given -901 336330753 gbak_unknown_switch Found unknown switch Found unknown switch -901 336986113 fbsvcmgr_bad_am Wrong value for access mode -901 335740930 gfix_invalid_sw Invalid switch @1 -901 335544322 bad_dbkey Invalid database key -901 336986114 fbsvcmgr_bad_wm

version of the product -901 335740929 gfix_db_name Data base file name () already given -901 335740930 gfix_invalid_sw Invalid switch -901 335740932 gfix_incmp_sw Incompatible switch combination 335740933 gfix_replay_req Replay log pathname required -901 335740934 gfix_pgbuf_req Number of page buffers for cache Firebird 1.5 Error Codes Updated 04/30/04 p. 17 required -901 335740935 gfix_val_req value required -901 335740936 gfix_pval_req Positive numeric value required -901 335740937 gfix_trn_req Number of transactions per sweep required -901 335740940 gfix_full_req "full" or "reserve" required

setting, using gfix -use full | reserve database_name Chapter 2. Command-line Options 11 where full uses 100% of each page and reserve reserves some space for subsequent updates. See the gfix manual for You must either always use the gbak or nbackup tools which know how the database works, or, use gfix to shut the database down completely before you even attempt to backup the database file(s). Gbak restore a database onto any version of Firebird. You can, if you wish, change the SQL Dialect using gfix. Under normal circumstances, restoring a database takes place as a single transaction. If the restore

отключения для некоторых разовых действий, требующих принудительного завершения работы сервера. Утилита gfix теперь имеет переключатель -NoLinger, который сразу закроет указанную базу данных, после того как a record stream. Попытка получения в потоке записей записи, следующей за последней. 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n. 0 335544875 bad_debug_format Bad debug info 335544712 expec_positive Positive value expected. Ожидается положительное значение. -901 335740929 gfix_db_name Database file name (@1) already given. Имя файла базы данных (@1) уже отдано. -901 336330753

TPB parameter isc_tpb_ignore_limbo, available in the API since InterBase times and mainly used by gfix. Chapter 10. Transaction Control 389 RESERVING The RESERVING clause in the SET TRANSACTION statement exist 100 335544374 stream_eof Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect | set database dialect n 0 335544875 bad_debug_format Bad debug info Unsigned short integer expected -842 335544712 expec_positive Positive value expected -901 335740929 gfix_db_name Database file name (@1) already given -901 336330753 gbak_unknown_switch Found unknown switch

Firebird 4 security database, it is also possible to copy the security4.fdb to security5.fdb and use gfix -upgrade to upgrade from ODS 13.0 to ODS 13.1, but we recommend using the backup and restore route $(install)/doc Firebird server firebird $(install)/bin Command-line tools isql, gbak, nbackup, gfix, gstat, etc. $(install)/bin Plugins libEngine13.so, libSrp.so, libudr_engine.so, etc. $(install)/plugins $(install)\doc Firebird server firebird.exe $(install) Command-line tools isql.exe, gbak.exe, nbackup.exe, gfix.exe, gstat.exe, etc. $(install) Plugins engine13.dll, srp.dll, udr_engine.dll, etc. $(install)\plugins

fbserver (SS) or fb_inet_ server (CS) /bin Command-line tools isql, gbak, nbackup, gsec, gfix, gstat, etc. /bin Sample database employee.fdb /examples/ empbuild UDF et_server.exe (CS) \bin Command-line tools isql.exe, gbak.exe, nback- up.exe, gsec.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee.fdb \examples\ empbuild preferred admin tool. If the restored database is good, shut down the old database (you can use the gfix command-line tool for this; see the InterBase Operations Guide; a link is given in the next section)

fbserver.exe (SS) or fb_inet_server.exe (CS) \bin Утилиты командной стро- ки gbak.exe, gfix.exe, gstat.exe, etc. \bin Образец базы данных employee.fdb \ examples Библиотеки Firebird fbserver (SS) or fb_ inet_server (CS) /bin Утилиты командной стро- ки gbak, gfix, gstat, etc. /bin Образец базы данных employee.fdb / examples Библиотеки