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

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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . split large backup files even if gsplit is supplied with your Firebird release. Gsplit is only supplied with the Windows version of Firebird 1.5, it is not supplied with the Linux version. Linux doesn’t it can split files using the split command as well as using gbak.  In testing with Firebird 1.5 and Firebird 2.0 on Windows XP Home and WIndows 2000, gsplit doesn’t seem to work properly and always

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . Table of Contents 3 Chapter 1. Introduction This manual provides reference material for the Firebird Interactive SQL Utility (isql), and instructions on how to use it to perform tasks within the database isql utility in Firebird version 1.5 and higher. Chapter 1. Introduction 4 Chapter 2. Overview The isql utility is a text-mode client tool located in the bin directory of the Firebird installation. It

Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 are: • root • firebird • interbase • interbas (without the 'e') Normal users, ie all those accounts not listed above, can only see their own user details from version 2.0 of Firebird. They can, however

Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 12. Database -⁠? switch, results in the following screen of helpful information: gfix usage instructions for Firebird 3.0.7 usage: gfix [options] plausible options are: -ac(tivate_shadow) activate

Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . of 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 you had to supply an invalid switch (see -help below) in order to see the list of valid ones.  Firebird 2.5 onwards. -FE[TCH_PASSWORD] | stdin | /dev/tty This switch causes the

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

Firebird 2.1 Error Codes Firebird 2.1 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 101 335544366 segment Segment buffer length shorter than user record. -85 335544757 error_updating_sec_db An error occurred while updating the security Firebird 2.1 Error Codes database. -103 335544571 dsql_constant_err Data type for constant unknown -104 delimited by double quotes -104 335544764 transitional_date DATE must be changed to TIMESTAMP Firebird 2.1 Error Codes -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect @1 does not support

4.4. Datenbanktrigger unterdrücken (Firebird 2.1+). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.5. Direkte I/O (Firebird 2.1.4+) . . . . . . . . . . . . . . Informationsoptionen (Firebird 2.5+) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.7. Sicherungen auf Remote-Servern (Firebird 2.5+). . . . . . Nbackup ist ein Backup-Werkzeug, das seit Firebird 2.0 inkludiert ist. Es bietet Möglichkeiten, die in dem bekannten Firebird Backup-Tool gbak — bereits in Firebird vorhandenes Backup-Tool — nicht vorhanden