Use the following startup parameters to configure truncating and archiving your database log file.

Table 1. Log file truncation parameters
Parameter Description
-lgTruncateFrequency Specify the frequency of when your log file is truncated. Valid values include daily, one day per week, or the last day of the month. Must be used with -lgTruncateTime.
-lgTruncateTime Specify the time of day when your log file is truncated. Valid values are based on a twenty four hour clock, 00:00 (midnight) to 23:59 (one minute before midnight). Must be used with -lgTruncateFrequency.
Note: If the database is offline or in single user mode when the time and frequency parameters indicate, no truncation occurs until the next time the parameters are satisfied.
-lgTruncateSize Specify the size in MB when the database log file is to be truncated. Valid values range begins at 0 and does not have a maximum value. The value of 0 (default) indicates that truncation based on size is disabled.
Note: If the database is in single user mode when the log file reaches the specified size, it is not truncated. It is truncated the next time the database is brought online in multi-user mode, provided the size criterion is still met. If the log file reaches the specified size while writing a message, the database log file is truncated at the conclusion of writing the message.

The table that follows describes the parameters for archiving your database log file. If you do not configure truncation of your database log file, it is not archived.

Table 2. Log file truncation parameters
Parameter Description
-lgArchiveEnable Specify that you want the database log file archived before truncating it.
Note: If archiving the log file fails for any reason, the log file is not truncated.
-lgArchiveDir Specify the fully qualified path name of the directory where you want the archive files written.