OEM: Database startup parameters "-lgTruncateFrequency" and "-lgTruncateTime" are not working

OEM: Database startup parameters "-lgTruncateFrequency" and "-lgTruncateTime" are not working
Unable to set the "-lgTruncateTime" parameter in OEM.

OEM for Daily "lgtruncatefrequency=0" is ignored and log file truncation never happens

OpenEdge 11.7.3, The following database startup parameters manage the database logfile:

• -lgArchiveDir - Database log file archive directory
• -lgArchiveEnable - Archive database log file before truncation
• -lgTruncateFrequency - Frequency of database log file truncation. Used in conjunction with -lgTuncateTime  to determine the time of the truncation on the specified days. 
  • -1 == "Not Enabled"
  • Values are {0 .. 8} where:
    • 0 == Daily,
    • {1,2,...,7} == indicate weekly on each day Monday (1),Tuesday (2),..., Sunday (7),
    • 8 == monthly, on the last day of the month.
• -lgTruncateTime - Time of day for the database log file truncation (in hours and minutes: HH:MM)
• -lgTruncateSize - The maximum size the database log file can grow before truncation (in megabytes)

There are two issues with the logfile archive parameters:

lgTruncateTime: Is set incorrectly.  This property takes time value as a string: format HH:MM, where the-time-of-day must falll within a valid range: 00:00 through 23:59
This setting cannot be a comma separated multiple time values - HH:MM,HH:MM,HH:MM
(THE-) Time of day for truncation (-lgTruncateTime):     13:00

lgTruncateFrequency: This property takes value from ranging from -1 to 9.
Setting this value to truncate Daily 0 (zero) in the OEM/OEE database parameter configuration screen "lgtruncatefrequency=0" is ignored and log file truncation never happens as this is set to -1 which denotes "Not Enabled". This needs to be addressed for lgTruncateFrequency to accept zero also as valid value.
When setting the value other than zero works fine.

 

Until the fix is available, use the workaround below.

To configure Daily database log file truncation. 

• Edit conmgr.properties and configure daily db lg file truncation in: otherargs=-lgTruncateFrequency 0  
• It must be used in conjunction with -lgTuncateTime to determine the time to truncate and archive
• The lg file truncation time accepts one value anywhere within the range 00:00 through 23:59
• To disable database logfile management set : lgtruncatefrequency=-1

Example: <dlc>\properties\conmgr.properties
    

Progress Article:

How to truncate the log file while the database is running for OpenEdge version 10.1A and later.