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


1  EXECUTE FUNCTION
1 admin
1 task
2  ( "ontape archive
1! file
1 directory
1 tape
3? level
4.1! 0
4.1 1
4.1 2
3  "
3  , "location"
3? ,"block_size"
3  ) ;
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");