IQ_POINT_IN_TIME_RECOVERY_LOGGING Option

• Option can be set at the database (PUBLIC) level only.

• The DBA privilege is required to set this option.

• Requires the SET ANY SYSTEM OPTION system privilege to set this option.

Setting IQ_POINT_IN_TIME_RECOVERY_LOGGING to 'ON' is the second of two steps required to enable point-in-time recovery logging:

1. Set IQ_POINT_IN_TIME_RECOVERY_LOGGING to 'ON':

   SET OPTION PUBLIC.IQ_POINT_IN_TIME_RECOVERY_LOGGING = 'ON'

2. Identify the directory where you want to open the new point-in-time recovery logs:

   ALTER DBSPACE  IQ_SYSTEM_LOG RENAME ' new-directory-specification/file-prefix '

   By default, SAP IQ saves the point-in-time recovery log in the same directory as the .db file. This IQ_SYSTEM_LOG RENAME parameter directs log output to another directory.

   The new-directory-specification must point to an existing directory. For multiplex servers, this directory must reside on a shared file system and be writable by all multiplex nodes.

3. Perform a FULL data backup:

   BACKUP DATABASE ...
       TO <archive_device>

Point-in-time recovery logging to the IQ system log only becomes fully enabled when the data backup begins.

To disable point in time recovery logging, set the IQ_POINT_IN_TIME_RECOVERY_LOGGING option to OFF: Setting this option to OFF, disables point-in-time recovery immediately. To re-enable point-in-time recovery, you must complete all steps in this procedure, including a full backup.