ontape archive argument: Backup the data on your database (SQL administration API)
Use the ontape archive argument with the admin() or task() function to create a backup of your database data.
Syntax
>>-EXECUTE FUNCTION--+-admin-+--(--"ontape archive--------------> '-task--' .-file------. >--+-----------+--+-------------+--"--,--"location"-------------> +-directory-+ | .-0-. | '-tape------' '-level-+-1-+-' '-2-' >--+---------------+--)--;------------------------------------->< '-,"block_size"-'
Element | Description | Key Considerations |
---|---|---|
location | The path to the file or directory or tape device. | |
block_size | The block size, in KB, of the device to which ontape writes during a storage-space backup. | The default block size is 512 KB. |
Usage
This function invokes the ontape utility to create a backup.
There are three devices that you can choose
from for the location of the backup:
- file
- An existing file. This is the default value.
- directory or dir
- An existing directory path specified by location.
- tape
- An existing tape device.
Examples
This function creates a level 0
archive in the directory path /local/informix/backup/:
EXECUTE FUNCTION task("ontape archive","/local/informix/backup/");
This function creates a level 0 archive in the
directory path /local/informix/backup/ with a
block size of 256 KB:
EXECUTE FUNCTION task("ontape archive directory level 0",
"/local/informix/backup/","256");