SET RECOVERFILE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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 RECFILE.RECGRP
SQLAudit >> set recoverfile
Current Recovery File: RECFILE.RECGRP
Enter Recovery File Name or '//' to keep current name
Recovery File Name or '//' to STOP command >> SQLAUREC.RECGRP
Current Recovery File: SQLAUREC.RECGRP
SQLAudit >>
MPE/iX 5.5 Documentation