Start/notes.ini Parameters/TRANSLOG_MAX_ARCHIVE_EXTENTS

TRANSLOG_MAX_ARCHIVE_EXTENTS

🛠️
Parameter: TRANSLOG_MAX_ARCHIVE_EXTENTS
Short description: Maximum number of archive extents in archive translog style – limits the disk usage of the archive log.

Profile

Parameter
TRANSLOG_MAX_ARCHIVE_EXTENTS
Category
Transaction log
Component
Server
Available since
8.5.1
Supported versions
9.0.1, 10.0, 11.0, 12.0, 14.0, 14.5, 14.5.1
GUI equivalent
notes.ini only (no GUI)
Possible values
Integer (number of extents)

Description

In archive style (TRANSLOG_Style=1), filled translog extents are not overwritten directly but kept until a backup tool has secured them. So that the translog volume cannot grow indefinitely, TRANSLOG_MAX_ARCHIVE_EXTENTS limits the number of archive extents that can exist simultaneously. If the limit is reached and extents have not yet been backed up, the server can only accept new transactions again once the backup has run – a safeguard against disk full.
In combination with a properly configured backup, the value is only a safety net; without a backup pipeline, circular style (TRANSLOG_Style=0) should be used instead.

Example configuration

TRANSLOG_Style=1
TRANSLOG_MAX_ARCHIVE_EXTENTS=512

Notes & pitfalls

  • Only useful in archive style; has no effect in circular style.
  • Values that are too low can block the server when the backup is delayed – know your backup cadence.
  • Takes effect after a server restart.
  • Complementary to TRANSLOG_Style, TRANSLOG_Path, TRANSLOG_MaxSize.