jpg) ## Firebird 5 Quick Start Guide IBPhoenix Editors, Mark Rotteveel, Firebird Project Members 0.2: 8 November 2023 ## Table of Contents 1. About this guide ..... 3 2. The Firebird licenses . .... 4 3. Installing Firebird ..... 5 3.1. Installation kits ..... 5 3.2. Installing the Firebird server ..... 5 3.2.1. Before installation ..... 5 3.2.2. Installation drives ..... 7 3.2.3 Testing your installation ..... 9 3.4.1. Pinging the server ..... 10 3.4.2. Making sure that the Firebird server is running ..... 10 3.5. Performing a client-only install ..... 13 3.5.1. Windows ..

 Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 ## Table of Contents 1. Introduction .. 3 2.3. Shadow Files ..... 3 3. Standard Database Page Header ..... 5 4. Database Header Page — Type 0x01 ..... 7 5. Page Inventory Page — Type 0x02 ..... 14 6. Transaction Inventory Page — 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

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3. Invoking Isql. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. Starting An Isql Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

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

 # Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 ## Table of Contents 1. Introduction Command line Options ..... 3 3. Gsplit Command Parameters ..... 4 4. Splitting Backups ..... 5 5. Joining Backup Files ..... 7 Appendix A: Document history ..... 8 Appendix B: License notice 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

 # Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 ## Table of Contents 1. Introduction ..... 2 4.5. OS Admin Mapping ..... 11 4.6. Help ..... 12 4.7. Version Information ..... 12 5. Batch Mode ..... 13 5.1. Displaying User Details ..... 13 5.2. Adding New Users ..... 13 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

 # Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 ## Table of Contents Command Line Options ..... 4 3. 6fix Commands ..... 5 4. Shadow Files ..... 7 4.1. Activating Shadows ..... 7 4.2. Killing Shadows ..... 8 5. Set Database Page Buffers ..... 10 6. Limbo Transaction .... 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

 # Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 ## Table of Contents 1. Introduction 15 4.2. Malformed String Errors During Restores ..... 15 4.3. Speeding up the Restore ..... 16 5. Security Of Backups ..... 17 6. Backup & Restore Recipes ..... 18 6.1. Backup & Restore 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

[Image](/uploads/documents/8/1/2/f/812fdd80ba8d747e09890b43de3fb0bc/p1_1.jpg) Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 ## Table of Contents 1 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.5. The NULL 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 operations

### Firebird 1.5 Error Codes from msg.gbak, release sources |SQLCODE|GDCODE|SYMBOL|TEXT| |---|---|---|---| |101|335544366|segment|Segment buffer length shorter than expected| |100|335544338|from\_no\_match|No |-902|335544472|login|Your user name and password are not defined. Ask your database administrator to set up a Firebird login.| |-902|335544506|shutinprog|Database <string> shutdown in progress| |-902|335544528|shutdown|Database <string> is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login.| |-902|335544791|file\_in\_use|The file <string> is currently in use by another process