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

Read syntax diagramSkip visual syntax diagram
>>-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");
     

Copyright© 2019 HCL Technologies Limited