HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

PURGELOG 

Purges a log file that is not needed.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> PURGELOG  DBEnvironment Name:  DBEnvironmentName  Maintenance Word:

MaintenanceWord  Log Identifier:  LogIdentifier  Purge Log File (y/n)?
{Y[es]}
{N[o] }
Parameters 

DBEnvironmentName       is the name of the DBEnvironment with which the
                        file you are changing is associated.

MaintenanceWord         is the maintenance word.

LogIdentifier           is the log identifier number assigned to the file
                        you wish to purge.

Description 

   *   This command lets you remove a log file provided it does not
       contain any active transactions and has either been backed up or
       else never used.  In the case of dual logging, both physical files
       corresponding to the identifier number are deleted.

   *   If you try to purge a log file that is either in use or that has
       not been backed up, you will receive an error message.

   *   The DBEnvironment may be in use while this command is executed.

Authorization 

You must be the DBECreator or have SM capability to purge a log file.

Example 

     >> purgelog 
     DBEnvironment Name:  PartsDBE 
     Maintenance Word:   Return  
     Log Identifier: 2 
     Purge Log File (y/n)? y 

MPE/iX 5.5 Documentation