Managing log file size

The database log (lg) file expands as you use the database. If it becomes too large, you can reduce its size by removing old log entries. To remove log entries from an lg file, use the Log Maintenance (PROLOG) utility or a text editor. Preserve the information in your log file by backing it up prior to truncation.

Enter the following command to remove entries from an event log file:

The PROLOG utility removes all but the most recent entries from the log file. Use the -online parameter when you need to truncate the log file for a database that is online. For complete details on the PROLOG utility, see PROLOG utility.