DPB Parameters

From InterBase
Jump to: navigation, search

There are two tables listing the DPB parameters: Table 4.2 groups the DPB parameters by purpose. Table 4.3 lists the parameters alphabetically and gives value ranges and length for each.

Table 4.2 DPB Parameters Grouped by Purpose

Description Parameter
User Validation Parameters
User name isc_dpb_user_name

Password isc_dpb_password

Encrypted password isc_dpb_password_enc

Database system encryption password isc_dpb_sys_encrypt_password

System database administrator’s user name isc_dpb_sys_user_name

Authorization key for a software license isc_dpb_license

Database encryption key isc_dpb_encrypt_key

Environmental Control
Number of cache buffers isc_dpb_num_buffers

dbkey context scope isc_dpb_dbkey_scope

System Management
Force writes to the database to be done asynchronously or synchronously isc_dpb_force_write


Instructs server to include validation checks during a database restore isc_dpb_gbak_validate


Specify whether or not to reserve a small amount of space on each database page for holding backup versions of records when modifications are made. isc_dpb_no_reserve


Specify whether or not the database should be marked as damaged isc_dpb_damaged


Perform consistency checking of internal structures isc_dpb_verify


Specifies database space preallocation isc_dpb_preallocation


Use this parameter to request database preallocate information that is stored on the database header. isc_info_dpb_preallocation


This Directive initiates an online dump isc_dpb_online_dump


This parameter indicates that the current online dump files should be deleted and a full database dump executed (optional) isc_dpb_old_overwrite


Specifies the name of an online dump file, up to 255 characters isc_dpb_old_file_name


This parameter specifies the number of pages for the online dump file (optional) isc_dpb_old_file_size



The indicates the backup database to archive. The equivalent command-line is: gbakarchive_database isc_dpb_archive_database



This parameter specifies the backup journals to archive. The equivalent command-line is: gbakarchive_journals sc_dpb_archive_journals



This indicates the database to recover from archive. The equivalent command-line is: gbakarchive_recover isc_dpb_archive_recover



This deletes all files in RDB$JOURNAL_ARCHIVES with RDB$ARCHIVE_SEQUENCE less than the requested sequence. The equivalent commandline is: gfix-archive_sweep<n>. isc_dpb_archive_sweep



Configures the maximum number of database dumps allowed in the archive. The equivalent command-line is: gfix-archive_dumps<n>. isc_dpb_archive_dumps



Shadow Control
Activate the database shadow, an optional,duplicate, in-sync copy of the database. isc_dpb_activate_shadow

Delete the database shadow isc_dpb_delete_shadow

Replay Logging System Control
Activate a replay logging system to keep track of all database calls isc_dpb_begin_log

Deactivate the replay logging system isc_dpb_quit_log

Deactivate the replay logging system isc_dpb_quit_log

Character Set and Message File Specification
Language-specific message file isc_dpb_lc_messages

Character set to be utilized isc_dpb_lc_ctype

Advance to Next Table