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