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 2 Table of Contents About this guide ........................................................................................ 3 The Firebird licenses ...................................................................................... .. 8 Installing Firebird ................................................................................................................................... 9 Installing the Firebird server .........

Firebird 2 Schnellanleitung IBPhoenix Editoren Mitglieder des Firebird-Projekts Übersetzung ins Deutsche: Thomas Steinmaurer 28. November 2006 – Dokumentenversion 3.3-de 2 Inhaltsverzeichnis Über 5 Installation von Firebird ......................................................................................................................... 7 Installation des Firebird Servers ............ ............................................................................................ 23 Firebird SQL ...........................................................................................

Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Database Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Table of Contents 1 Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to

Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Gsplit Command line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

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

Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Command Line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. Command Line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 12. Database

Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Command-line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 Table of Contents 1. What is NULL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2. NULL support in Firebird SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.4. Testing DISTINCTness (Firebird 2+) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .