.......................................................................... 29 Other Libraries or Files Needed by Clients ............................................................................ 29 then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the files in the /misc/upgrade/metadata directory of your Firebird 2.1 installation. Running Multiple Instances installation, there will be situations where the Firebird engine, command-line tools, cron scripts, batch files, installers, etc., will not work as expected. If the Windows installer program finds a value for

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 5. Joining Backup Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . restore a database. Up until Interbase 5.0, dump files were limited to 2 Gb by the gbak utility itself — even if running on a system which allowed files to be 4 Gb. Coming up in the remainder of this required as gbak allows large files to be split directly. The details for gsplit given here are for reference only and you are advised to use gbak to split large backup files even if gsplit is supplied

. . . . . . . . . . . . . . . . . . . . . . . 22 6.10. Backup & Restore With & Without Shadow Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6.11. Remote Backups -C[REATE_DATABASE] create database from backup file -CO[NVERT] backup external files as tables -E[XPAND] no data compression -FA[CTOR] blocking from backup file (restore) gbak:backup options are: -CO(NVERT) backup external files as tables -E(XPAND) no data compression -FA(CTOR) blocking

efficient if the number of simultaneous connections grows. Permits fast, direct I/O to database files for local connections on Linux. The client process must have filesystem-level access rights to the command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners). • Release notes – essential reading! Firebird 2.0 and 2.1 Quick Start stallDir>) — /opt/firebird (may vary per distribution) Release Notes and other documen- tation Various files /doc Firebird server fbserver (SS) or fb_inet_ server (CS) /bin Command-line

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.3. Shadow Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . answered on the Firebird Support forums where the developers hang out. Much hex dumping of database files was undertaken in the creation of this document, but no Firebird databases were harmed during this the DBA can specify the page size, or leave it to default. This action creates a database file, or files, with enough space allocated to create all the system tables and indices. New pages will be added

for each client connection. Using a locking mechanism, it allows shared connections to database files. • SuperClassic (ThreadedShared) is a single server process. Client connections are handled by separate you do want to run Firebird as an application, it is recommended to install it outside the Program Files folder to ensure you have sufficient access rights. During installation, you have the option of providing the “old” InterBase names), to maintain compatibility with third-party products which need these files. Some extra pieces are also needed for the client-only install. 3.5.1. Windows No separate installation

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Shadow Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . database to be usable with present ICU version -k(ill_shadow) kill all unavailable shadow files -l(ist) show limbo transactions -me(nd) prepare corrupt database for to pass the -⁠u[ser] and -⁠pa[ssword] parameters. Chapter 3. Gfix Commands 6 Chapter 4. Shadow Files A shadow file is an additional copy of the primary database file(s). More than one shadow file may

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 482 RDB$FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . material from the LangRef Updates, Russian language support forums, Firebird release notes, read- me files and other sources. By the end of 2014, they had the task almost complete, in the form of a Microsoft

command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners!) • Release notes – ESSENTIAL READING! Classic or Superserver? Firebird efficient if the number of simultaneous connections grows. Permits fast, direct I/O to database files for Linux local connections. On Linux, local connections are made network-style, via localhost (often NT, 2000, XP, ...) Installation directory (referred to hereafter as ) C:\Program Files\Firebird Firebird server ibserver.exe (SS only) \bin Command-line tools gbak.exe, gfix

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 722 RDB$FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 731 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . overwriting existing *.res files belonging to the database.  /tzdata is the default directory where Firebird looks for the time zone database. It can be overridden with the ICU_TIMEZONE_FILES_DIR environment