SET RECOVERFILE

Defines the recovery file name which can be used by the AUDIT command.

Scope

SQLAudit Only

SQLAudit Syntax

SQLAudit >> SE[T] REC[OVERFILE] FileName SQLAudit >> SE[T] REC[OVERFILE] Recovery File Name or '//' to STOP command >> FileName

Parameters

FileName: is the name of the recovery file the AUDIT command is to use. Enter FileName in all uppercase letters, so that you can see the file within SQLAudit.

Description

This command is used to define the name of the recovery file to be used by the AUDIT command. This file will only be created if the AUDIT command encounters an error while writing to the results file. When this file is created, SQLAudit places audit point information in the file to reflect the set of transactions that have been audited.
If the file already exists at the time that the AUDIT command attempts to create it, an error occurs and the file is not created.
The default file name setting for this option is SQLAUREC.

Authorization

No authorization is required to use this command.

Example



   SQLAudit >> set recoverfile /tmp/RECFILE



   SQLAudit >> set recoverfile



   Current Recovery File: /tmp/RECFILE



   Enter Recovery File Name or '//' to keep current name



   Recovery File Name or '//' to STOP command >> /tmp/SQLAUREC



   Current Recovery File: /tmp/SQLAUREC

   SQLAudit >>