command-line utility for installing and uninstalling the Firebird service. It does not apply to Windows systems that do not have the ability to run services (Win9x, WinME). For detailed usage instructions, refer fb_inet_server.exe on Windows that listens for connection requests from network clients. On POSIX systems, the [x]inetd daemon performs this listening role. The stub process or daemon creates a separate process for each successful connection. Each process has its own private page cache and, on 32-bit systems, can use up to 2 GB of RAM. • Superserver is a process named fbserver.exe on Windows, fbserver on

server and tuning your installation, please refer to Chapters 4-6 of the Using Firebird manual, distributed on the IB- Phoenix CD. The Firebird Quick Start Guide started life as Chapter 1 of the Using Firebird file or decompressing a structured WinZip .zip file – it is strongly recommended that you use the distributed release kit the first time you install Firebird. The Windows executable installa- tion script, Windows 2000 and XP, the Guardian is a convenience rather than a necessity, since these two operating systems have the facility to watch and restart services. It is recommended that you keep Guardian active

locations of a Firebird installation on Linux. Some of the locations may be different on other Unix-like systems. Table 2. Firebird 2 component locations on Linux Component File Name Default Location Installation Typical locations on 32- bit systems are: • for Windows 95/98/ME: C:\Windows\System • for Windows NT/2000: C:\WINNT\System32 • for Windows XP: C:\Windows\System32 For 64-bit systems, read the next note. Firebird Firebird 2.0 and 2.1 Quick Start 9 Important notice for 64-bit Windows users On 64-bit Windows systems, the “Program Files” directory is reserved for 64-bit programs. If you try to install a 32-bit application

snapshot build or decompressing a .zip archive — it is strongly recommended that you use the distributed release kit (.exe for Windows, .tar.gz for Linux), especially if this is the first time you install Chapter 3. Installing Firebird 9 3.4.1. Pinging the server The ping command — available on most systems — is a quick and easy way to see if you can connect to a server machine via the network. For example launched, the Firebird server should be running: On Linux or other Unix-like systems As a service. On Windows server systems As a service or as an application. Service is default and highly recommended

databases are considered an anachronism. It made sense to use multi-file databases on old file systems where the size of any file is limited. For instance, you could not create a file larger than 4 GB • The UDF libraries (ib_udf, fbudf) are no longer distributed in the installation kits • Most of the functions in the libraries previously distributed in the shared Chapter 5. Data Definition (DDL) Statements problems may be very important for web sites handling thousands of concurrent writers, or for ERP/CRM systems operating in large corporations, most application programs do not need to work in such conditions

databases are considered an anachronism. It made sense to use multi-file databases on old file systems where the size of any file is limited. For instance, you could not create a file larger than 4 GB problems may be very important for web sites handling thousands of concurrent writers, or for ERP/CRM systems operating in large corporations, most application programs do not need to work in such conditions optional keyword WORK is supported just for compatibility with other relational database management systems that require it. • The keyword RELEASE is available only in Embedded SQL and enables disconnection

If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. could be the size of a CD, the 2GB limit on individual file sizes on a DVD, where some Unix file systems have a 2 GB limit and so on. Gbak allows the dump files to be split into various sizes (with a database if it doesn’t already exist, and will exit with an error if it does. In POSIX compatible systems, the error code in $? is 1 in this case. Further examples of backing up and restoring remote databases

 It is possible on some operating systems that users will not be able to run gsec, even if they know the SYSDBA password. This is because those operating systems allow the system administrator to set Windows (Change '1_5' to suit your Firebird version) • /opt/firebird for Linux and other Unix systems. The gsec utility manipulates data in the table(s) in the security database, and by doing so, allows If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards.

operating systems imposed a limit which defined how large a 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 the file system has the largefiles option turned on. This limit still exists on some operating systems. Gsplit is a filter utility introduced with Interbase 5.0 which allows the output file from the

If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. populated with data it can be changed to read only mode, and then used on a CD (or other read only file systems) with no problems.  Firebird uses SQL internally to maintain its internal structures with details Chapter 13. Database Validation and Recovery 34 Chapter 14. Database Write Mode Many operating systems employ a disk cache mechanism. This uses an area of memory (which may be part of your server’s overall