The dump configuration configuration parameter group represents these user-created dump configurations:
stripe directory – is the directory in which files are archived during the dump operation. Archived files are typically named using this convention:
database_name.nump_type.date-timestamp.stripeID
external api name – is the name of the external API (byte stream device) to be used for the dump operation, and must conform to this format:
External API Name::Options
number of stripes – is the number of stripe devices to use during the dump operation. By default, a single stripe device is used.
number of retries – is the number of times the server tries the dump operation for nonfatal errors up to a maximum of 5 times. The default is 0.
block size – is the block size for the dump device and overrides the default block size for the device. blocksize must be at least 1 database page, and an exact multiple of the database page size.
compression level – is the compression level for compressed dumps. By default, compression is disabled.
retain days – is the number of days during which the dump cannot be overwritten. Backup Server requires confirmation to overwrite an unexpired volume. By default, retaindays is 0, and dumps can be overwritten.
init – specifies whether the volume must be reinitialized. The default is “noinit”.
verify – specifies if Backup Server must perform a minimal page-header or full structural row check on the data pages as they are copied to archives. There is no structural check made to global allocation map (GAM), object allocation map (OAM), allocation pages, indexes, text, or log pages. By default, there is no verification of data pages durig archiving.
notify – the default message destination to Backup Server. One of:
client - route messages to the terminal that initiated the dump command.
operator_console - route messages to the terminal on which Backup Server is running
remote backup server name – specifies the remote Backup Server used for a dump operation. The default is SYB_BACKUP.
Example 1 Contains multiple dump configurations as created in the Adaptive Server configuration file:
[dump configuration : dmp_cfg1] stripe_dir = /work/dmp_cfg1_dir ext_api = DEFAULT num_stripes = 5 retry = 0 blocksize = DEFAULT compression = 9 retaindays = DEFAULT init = DEFAULT verify = DEFAULT backup_srv_name = DEFAULT [dump configuration : dmp_cfg2] stripe_dir = /work/dmp_cfg2_dir ext_api = syb_tsm num_stripes = DEFAULT retry = 3 blocksize = DEFAULT compression = DEFAULT retaindays = DEFAULT init = DEFAULT verify = DEFAULT backup_srv_name = SYB_REMOTE