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
| task
}
("ontape archive
[ {
file
| directory
| tape
} ]
[
level
{
0
| 1
| 2
}
]
"
,"location"
[
,"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");