Log file truncate frequency (-lgTruncateFrequency)

Operating system and syntax	UNIX / Windows	-lgTruncateFrequency day
Use with	Maximum value	Minimum value	Default
Database Server	8	0	-1

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
-1¹	Do not truncate

¹ You cannot specify -1 as a parameter value, but it is visible and settable in PROMON and the _DbParams VST, indicating that truncation based on frequency is disabled.

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.