The -m(erge) command line switch, can be used to incorporate the error messages into the output files. The -m2 command line switch ensures that the stats and plan information derived from the SET STATS commands to a script file. The TMP setting on a client can be used to control where these script files will be stored, if an absolute file path is not specified. Chapter 4. Command Line Switches 9 of the commands available — unfortunately, some are missing. The help command also allows you to drill down for further information. To activate the help system, simply type HELP at the prompt, as shown

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

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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 648 RDB$FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 657 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Liste der Tabellennamen in der Datenbank und die Anzahl der Spalten in jeder Tabelle zurück. Eine “Drill-Down”-Abfrage für die abgeleitete Tabelle gibt die Anzahl der Felder und die Anzahl der Tabellen

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