Appendix A: Document history ..... 42 Appendix B: License notice ..... 43 ### Chapter 1. Introduction Gfix allows attempts to fix corrupted databases, starting and stopping of databases, resolving 'in 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 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

|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 ound 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| 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,

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

gfix_db_name-901335740930gfix_invalid_sw-901335740932gfix_incmp_sw-901335740933gfix_repl /td>335740934gfix_pgbuf_req ||||required| |---|---|---|---| |-901|335740935|gfix\_val\_req|Numeric value required| |-901|335740936|gfix\_pval\_req|Positive numeric required| |-901|335740937|gfix\_trn\_req|Number of transactions per sweep required| |-901|335740940|gfix\_full\_req|"full" or "reserve" required| |-901|335740941|gfix\_usrname\_req|User name

setting, using gfix -use full | reserve database_name where full uses 100% of each page and reserve reserves some space for subsequent updates. See the gfix manual for more slim. 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, который сразу закроет указанную базу данных, после того как следующей за последней.0335741039gfix_opt_SQL_dialect-sql_dialectset database dialect n.0-901335740929gfix_db_nameDatabase file name (@1) already given.Имя файла базы данных (@1)

parameter $ isc\_tpb\_ignore\_limbo $ , available in the API since InterBase times and mainly used by gfix. ## RESERVING The RESERVING clause in the SET TRANSACTION statement reserves tables specified in |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 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

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 serverfirebird$(install)/binCommand-line toolsisql, gbak, nbackup, gfix, gstat, etc.$(install)/binPluginslibEngine13.so, libSrp.so, libudr_engine c| |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|

(SS) or fb\_inet\_server (CS)|<installDir>/bin| |Command-line tools|isql, gbak, nbackup, gsec, gfix, gstat, etc.|<installDir>/bin| |Sample database|employee.fdb|<installDir>/examples/emppuild| exe (CS)|<InstallDir>\\bin| |Command-line tools|isql.exe, gbak.exe, nback-up.exe, gsec.exe, gfix.exe, gstat.exe, etc.|<InstallDir>\\bin| |Sample database|employee.fdb|<InstallDir>\\examples\\empfuild| 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)

exe (CS)<InstallDir>\binУтилиты командной строкиgbak.exe, gfix.exe, gstat.exe, etc.<InstallDir>\binОбразец базы данныхemployee fb_inet_server (CS)<InstallDir>/binУтилиты командной строкиgbak, gfix, gstat, etc.<InstallDir>/binОбразец базы данныхemployee