Performing Encapsulated Virtual Backups

For the system-level backup of table data to be consistent with the virtual backup without additional steps, the system-level backup must be made during the backup command and by the backup transaction.

The parameter VIRTUAL ENCAPSULATED 'shell-command' allows arbitrary shell commands to be executed as part of the backup operation to guarantee these semantics. If the shell commands return a non-zero status, the backup operation returns an error. The user must guarantee that the shell commands correctly perform the system-level backup.

Enter a BACKUP DATABASE command with the FULL VIRTUAL ENCAPSULATED clause in Interactive SQL.

Use a SQL statement similar to:

BACKUP DATABASE FULL VIRTUAL ENCAPSULATED
'dd if=iqdemo.iq of=iqdemo.iq.copy'
TO 'iqdemo.full'