Setting Database Properties
From InterBase
Go Up to Database Configuration and Maintenance
The Database Properties dialog enables you to display and configure certain database settings. You can access the Database Properties dialog by any of the following methods:
- Select a connected database (or any branch under the database hierarchy) in the Tree pane and choose Database|Properties.
- Select a connected database in the Tree pane and double-click Properties in the Work pane.
- Right-click a connected database in the Tree pane and choose Properties from the context menu.
The Database Properties dialog contains two tabs, Alias and General.
Contents
Alias Tab
The Alias tab of the Database Properties dialog is where you can specify an alias name for a database as well as the file path and file name of the selected database.
To edit database alias settings:
- Enter the alias name of the database in the Alias Name text field.
- Enter database file name, including the path where the file is located, in the File text field. If you prefer, you can also click the browse button
to locate the file you want.
If you want to change the database file name, the database must be disconnected before you access the Database Properties dialog. - If you need to view or configure the general database settings, click the General tab and see General Tab below for further information.
- Once you are finished making changes to the database properties click OK to save your changes, otherwise click Cancel.
General Tab
The General tab of the Database Properties dialog is where you can view such database settings as the database owner, secondary files and their start pages, the number of allocated database pages and the page size. You can also set such options as Forced Writes, Sweep Interval, SQL Dialect and Read Only.
To edit database general options:
- Choose option values in the Options table. You can specify options by clicking the option value and entering a new value, by choosing a new value from a drop-down list of values or by double-clicking the option value to rotate its value to the next in the list of values.
- If you need to view or configure the database alias settings, click the Alias tab and see Alias Tab above for further information.
- Once you are finished making changes to the database properties click OK to save your changes, otherwise click Cancel.
| Option | Value |
|---|---|
| Read Only | Option values are True and False. To make the database read only set the Read Only option to True. This prevents users from performing any DML or updates to the database. The default setting for this option is False. See Making a Database Read-only for more information. |
| Write Mode | Sets the database write mode. Available options are Asynchronous, Synchronous and Direct I/O |
| Sweep Interval | he sweep interval is the number of transactions that will occur before an automatic database sweep takes place. You can enter any positive number for the sweep interval, or zero to disable the automatic sweep. See Sweep Interval and Automated Housekeeping for further information on setting the sweep interval. |
| Database Dialect | An InterBase database SQL dialect determines how double quotes, large exact numerics, and certain data types such as SQLDATE, TIME, and TIMESTAMP are interpreted. In most cases you should choose dialect 3 in order to have access to all current InterBase features. For more information refer to Features and Dialects. |
| Page Buffers | Enter a numeric value. It lets you set the number of database page buffers. |
| Linger Interval | Set a value in seconds. It allows a database to remain in memory after the last user detaches. |
| Flush Interval | Enables database flush. The interval <number> is interpreted in units of seconds. |
| Reclaim Interval | Set a value in seconds. Determines how often the garbage collector thread will run to release memory from unused procedures, triggers, and internal system queries back to InterBase memory heap. |
| Group Commit | Available options are Yes and No when enabled allows transactions to be committed by a background cache writer thread. |
| Reserve Table Space | Available options are Yes and No. When set to No it disables space reservation on the database. |
| Embedded User Authentication | Option Values are Disabled and Enabled. Stores database user name and password information directly in the database. |