Use Log file truncate time (-lgTruncateTime) to specify a time to truncate the log file.

Operating system and syntax UNIX / Windows -lgTruncateTime HH:MM
Use with Maximum value Minimum value Default
Database Server 23:59 00:00 —
HH:MM

The time of day to truncate your log file, specified with a 24 hour clock. 00:00 is midnight, 23:59 is one minute before midnight. You can omit leading zeros, as long as there is a valid H and M separated by ":". For example 3:3 and 03:03 are equivalent.

You must specify both -lgTruncateFrequency and -lgTruncateTime. If you only specify one of the parameters, no truncation occurs. Use -lgTruncateFrequency to specify the day or days to truncate the log file. See Log file truncate frequency (-lgTruncateFrequency) 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, and there is no time-based attempt to truncate until the next time the parameters indicate.

The value for -lgTruncateTime 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.