not in use. Deleting all the data from a table will result in all slots being set to zero. Page fill bitmaps At the end of each pointer page is a bitmap array of two bit entries which is indexed by this page. Bit 1 set means this page is not propogated upwards. Bit 3 set means that this page/bucket is part of a descending index. Bit 4 set means that non-leaf nodes will contain record number information Appendix A: Fbdump Throughout some of this document you may have noticed that I’ve been using a tool named fbdump to display internal representations of Firebird Database pages. Maybe some of you are

between multiple databases, changing the number of page buffers and so on. Gfix is a general purpose tool for system administrators (and database owners) to use to make various 'system level' changes to databases.conf since Firebird 3.0), but it also can be set directly in the database header using gfix tool (and this setting will override firebird.conf and databases.conf, so be careful). The command to it is possible to clear out old rolled back transactions' garbage with a database backup by gbak tool. Gbak reads every table sequentially and thus visits every row in every table. Applications which

password ............................................................................... 12 An Admin tool ................................................................................................. gsec command-line utility. How to change the SYSDBA password Firebird comes with a command-line tool called gsec that is used to manipulate user accounts. Important With some Firebird installations eighth character, icuryy4m will work, as will icuryy4monkeys. An Admin tool The Firebird kit does not come with a GUI admin tool. It does have a set of command-line tools, ex- ecutable programs which

management tool called gsec. Although its functions can also be performed by a number of third-party GUI utilities, you should at least have a basic knowledge of gsec, since this is the official tool and it's needed. You can do this with gsec as shown above, or with any third-party Firebird administration tool. Protect databases on the filesystem level Anybody who has filesystem-level read access to a database even if the engine runs on it. Administration tools The Firebird kit does not come with a GUI admin tool. It does have a set of command-line tools – executable programs which are located in the bin subdirectory

any decent third-party Firebird Chapter 5. Server configuration and management 22 administration tool. Protect databases on the filesystem level Anybody who has filesystem-level read access to a database mapping is registered. 5.3. Administration tools The Firebird kit does not come with a GUI admin tool. It does have a set of command-line tools — executable programs which are located in the bin subdirectory query: SQL>select * from rdb$relations; Although you haven’t created any tables yet, the screen will fill up with a large amount of data! This query selects all rows in the system table RDB$RELATIONS, where

RDB$DATABASE; This syntax is still the only option in Firebird 2.  In Firebird’s command-line tool isql there are two additional commands for retrieving current generator values: SHOW GENERATOR GeneratorName; SEQUENCES; Please notice again that these SHOW … commands are only available in the Firebird isql tool. Unlike GEN_ID, you can’t use them from within other clients (unless these clients are isql frontends) ); end end Problems with trigger version 2: Some access components have the “bad habit” to auto-fill all the columns in an INSERT. Those not explicitly set by you get default values — usually 0 for

ACTIVE works just as well with constraint indexes as it does with others, as an index rebuilding tool. Only the table owner and administrators have the authority to use ALTER INDEX. ALTER INDEX Examples SEQUENCE (GENERATOR) A sequence or a generator is a database object used to get unique number values to fill a series. “Sequence” is the SQL-compliant term for the same thing which, in Firebird, has traditionally list(child) from marbletable where not marbles > 10 it’s the turn of Deirdre, Fritz and Isaac to fill the list. Chris and Hadassah are not included, because they aren’t known to have ten marbles or less

ACTIVE works just as well with constraint indexes as it does with others, as an index rebuilding tool. ALTER INDEX Examples 1. Deactivating the IDX_UPDATER index ALTER INDEX IDX_UPDATER INACTIVE; (GENERATOR) A sequence — or generator — is a database object used to get unique number values to fill a series. “Sequence” is the SQL-compliant term for the same thing which — in Firebird — has traditionally list(child) from marbletable where not marbles > 10 it’s the turn of Deirdre, Fritz and Isaac to fill the list. Chris and Hadassah are not included, because they aren’t known to have ten marbles or less

for the new user, all in the same add command. Alternatively, you may add a user then modify it to fill in the missing details. -delete This command removes the named user from the database. All

that you read the relevant chapter in each release notes volume and, if necessary, use a difference tool to merge existing settings into the new firebird.conf. - the firebird.log file is generated automatically to load the gds32.dll client library from the system directory. Firebird 2.x versions ship with a tool named 'instclient.exe' that can install a clone of fbclient.dll to the Windows System directory. This file version and can not make sense of a number string such as "2.0". InstClient.exe Tool This 'instclient.exe' tool can also install the FBCLIENT.DLL itself in the Windows system directory, if required