HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

UNLOCK AUDITPOINT 

Removes the current log lock on the DBEnvironment log files.

Scope 

SQLAudit Only

SQLAudit Syntax 

SQLAudit >> UNLOCK AUDIT[POINT]  Unlock Log Files (n/y) >> {n[o] }
                                                           {y[es]}
Parameters 

NO or YES               respond NO if you want to keep the log files
                        locked; respond YES to confirm removing the lock
                        on the log files.

Description 

   *   This command is used to unlock or remove any currently held lock
       on the DBEnvironment log files.  The lock must have been
       previously defined by the command GET AUDITPOINT or LOCK
       AUDITPOINT.

   *   When the log lock is removed (unlocked), transactions are no
       longer protected from being overwritten by database transactions.

   *   You must be connected to the DBEnvironment to use this command.
       If you have not connected to the DBE (using the SET DBENVIRONMENT
       command), SQLAudit will issue a warning and automatically issue
       the SET DBENVIRONMENT command on your behalf.

Authorization 

You must have DBA authorization in order to use this command.

Example 

     SQLAudit >> unlock auditpoint 

     Unlock Log Files (n/y) >> yes 

MPE/iX 5.5 Documentation