HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix I SQLAudit

UNLOCK AUDITPOINT

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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


Feedback to webmaster