cf6f1a459daff0dcdcd/p1_1.jpg) Firebird 2.0 and 2.1 Quick Start Guide IBPhoenix Editors Firebird Project members 11 July 2011, document version 3.11 covers Firebird 2.0–2.0.6 and 2.1–2.1.4 ## Table Table of Contents About this guide ..... 3 The Firebird licenses ..... 4 Classic or Superserver? ..... 5 Embedded Server for Windows ..... 6 What is in the kit? ..... 6 Default disk locations locations ..... 7 Linux ..... 7 Windows ..... 8 Installing Firebird ..... 9 Installing the Firebird server ..... 9 Installing multiple servers ..... 11 Testing your installation

 # Firebird 2 Schnellanleitung IBPhoenix Editoren Mitglieder des Firebird-Projekts Übersetzung ins Deutsche: Thomas Steinmaurer oder Superserver? ..... 3 Standardlaufwerkspfade ..... 5 Installation von Firebird ..... 7 Installation des Firebird Servers ..... 7 Installation mehrerer Server ..... 9 Testen Ihrer Installation erstellen ..... 23 Firebird SQL ..... 24 Vermeidung von Datenverlust ..... 28 Sicherung ..... 28 Wie man eine Datenbank beschädigt ..... 28 Wie bekomme ich Hilfe ..... 30 Das Firebird Projekt ....

s/c/2/9/d/c29d718dff1add52e02b1203b2fc175f/p1_1.jpg) Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 ## Table of Contents 1. Introduction ..... 2 2. Database this document is to try to explain what goes on inside a Firebird database. Much of the information in this manual has been extracted from the Firebird source code — mainly on the ODS related code and headers patiently 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

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2. Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Table of Contents 2 19.17. Show Secclasses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1880ebc897/p1_1.jpg) # Firebird Database Cache Buffer Norman Dunbar, Martin Köditz Version 1.2, 28 May 2020 ## Table of Contents 1. Introduction ..... 2 2. The Firebird Cache ..... 3 3. Using Appendix A: Document history ..... 9 Appendix B: License notice ..... 10 ### Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to each time they are required. The following description of how Firebird uses its cache is taken from a posting by Ann Harrison on the Firebird Support mailing list. The posting was in response to a query

/e/a/9/9ea98a65d2d4276aba4484f6ca6593e8/p1_1.jpg) # Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 ## Table of Contents 1. Introduction ..... 2 2. Gsplit Command line single file could become. This limit was 2 Gb on some systems, and 4 Gb on others. For example, on HP-UX 10.20 or 11.00 Unix systems, the maximum file size is 2 Gb unless the file system has the largefiles joined together and used to 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

[Image](/uploads/documents/8/2/5/0/825057c65a35ecff2aa089b69e47d082/p1_1.jpg) # Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 ## Table of Contents 1. Introduction ..... 2 2. Command Line various Firebird databases. Using various options, users can be added, amended or deleted from the security database. A privileged user is an account on the database server which the Firebird engine considers assumed to be privileged, these are:  • root • firebird • interbase • interbas (without the 'e') Normal users,

d5d2972d8c7f7a2f2976d/p1_1.jpg) # Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 ## Table of Contents 1. Introduction ..... 3 2. Command Line .... 27 11.2. Starting a Database ..... 28 11.3. New Startup and Shutdown States in Firebird 2.0 ..... 28 12. Database Page Space Utilisation ..... 30 13. Database Validation and Recovery management. • Cache management. • Starting and stopping a database. • And much, much more ... ### Chapter 2. Command Line Options Running gfix without a command (or an invalid command), or with the -? switch

b77c3add16bfacb3b385/p1_1.jpg) # Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 ## Table of Contents 1. Introduction ..... 2 2. Command-line Options ..... 3 2.1 the database backup and restore utilities supplied with Firebird. In Firebird 1.5 it is the only supplied utility of this kind while Firebird 2.x also has the nbackup utility which is described in another Running gbak in backup or restore modes. • Some caveats, gotchas and foibles of gbak. ### Chapter 2. Command-line Options #### 2.1. Common Options When running gbak in backup or restore mode, there

 Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 ## Table of state ..... 4 2. NULL support in Firebird SQL ..... 6 2.1. Disallowing NULL ..... 6 2.2. Testing for NULL ..... 6 2.3. Assigning NULL ..... 7 2.4. Testing DISTINCTness (Firebird 2+) ..... 7 2 2.5. The NULL literal ..... 8 2.5.1. Firebird 1.5 and below ..... 8 2.5.2. Firebird 2.0 and up ..... 8 3. NULL in operations ..... 9 3.1. Mathematical and string operations ..... 9 3.2. Boolean