Firebird Documentation IndexFirebird 3.0.2 Release NotesConfiguration Additions and Changes → “Per-database” Configuration
Firebird Home Firebird Home Prev: Expression of Parameter ValuesFirebird Documentation IndexUp: Configuration Additions and ChangesNext: New Parameters

Per-database” Configuration

Format of Configuration Entries
Parameters Available

Custom configuration at database level is achieved with formal entries in databases.conf.

Format of Configuration Entries

In aliases.conf the format for specifying a database alias was

 aliasname = /absolute/path/to/database_file
        

If you are not adding any database-specific configuration directives for an alias, the format is just as it was before, e.g.,

  emp = c:\Program Files\examples\empbuild\employee.fdb
 ** or  **
  emp = /opt/firebird/examples/empbuild/employee.fdb
 ** or  **
  emp = $(dir_sampleDb)/employee.fdb
        

A slightly more complex format is used for cases where certain non-global parameters are to be targeted at an indvidual databases. The entry for the database is defined by the alias declaration, as previously. The database-specific directives are listed below it, within curly brackets.

  #
  # Directives for MYBIGDB
  MYBIGDB = opt/databases/mybigdb.fdb
     {
        LockMemSize = 32M           # We know that MYBIGDB needs a lot of locks
        LockHashSlots = 19927       # and a hash table large enough for them
     }
          

Parameters Available

The following parameters can be copy/pasted to databases.conf and used as overrides for specific databases.

Table 6.1. Parameters available in databases.conf

Engine-related
DatabaseGrowthIncrement DeadlockTimeout DefaultDbCachePages
EventMemSize FileSystemCacheThreshold ExternalFileAccess
GCPolicy LockAcquireSpins LockHashSlots
LockMemSize MaxUnflushedWrites MaxUnflushedWriteTime
SecurityDatabase UserManager  
WireCompression WireCrypt WireCryptPlugin
Client-related Some parameters can be configured at the client connection via the DPB/SPB, as an alternative to configuring them in databases.conf. Please refer back to Scope of Parameters at the beginning of this chapter to understand these differences.
AuthClient Providers  
The following parameters can be configured ONLY via the DPB/SPB
ConnectionTimeout DummyPacketInterval IpcName
RemoteAuxPort RemotePipeName RemoteServiceName
RemoteServicePort TCPNoNagle  


Prev: Expression of Parameter ValuesFirebird Documentation IndexUp: Configuration Additions and ChangesNext: New Parameters
Firebird Documentation IndexFirebird 3.0.2 Release NotesConfiguration Additions and Changes → “Per-database” Configuration