Log file truncate frequency (-lgTruncateFrequency)

Use Log file truncate frequency (-lgTruncateFrequency) to specify how often to truncate your log file.

day

Specify the frequency for truncating your log file. The following table describes the accepted values and their meaning.

Parameter value	Definition
0	Truncate the log file daily
1	Truncate the log file on Monday
2	Truncate the log file on Tuesday
3	Truncate the log file on Wednesday
4	Truncate the log file on Thursday
5	Truncate the log file on Friday
6	Truncate the log file on Saturday
7	Truncate the log file on Sunday
8	Truncate the log file on the last day of the month
-11	Do not truncate

You must specify both -lgTruncateFrequency and -lgTruncateTime. If you only specify one of the parameters, no truncation occurs. Use -lgTruncateTime to specify the time of day to truncate the log file. See Log file truncate time (-lgTruncateTime) for more information.

When the day and time specified by -lgTruncateFrequency and -lgTruncateTime occurs, the log file is truncated, provided the database is online and no message is currently being written to the file. If the file is actively being written to, the truncation occurs as soon as the write completes. This guarantees that no message is split. If the database is offline or in single-user mode at the specified time, the database log file is not truncated. No attempt to truncate the log file is made until the next time the day and time criteria are satisfied, while the database is in multi-user mode.

The value for the -lgTruncateFrequency can be changed while your database is online with PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.