Log Retain Enable (logretain)

Configuration Type

Database

Parameter Type

Configurable

Default [Range]

No [ Recovery; Capture; No ]

Related Parameters

• User Exit Enable (userexit)
• Log Retain Status Indicator (log_retain_status)
• Backup Pending Indicator (backup_pending)

The values are as follows:

• No, to indicate that logs are not retained.

• Recovery, to indicate that the logs are retained, and can be used for forward recovery. In addition, if you are using data replication, the Capture program can write the updates recorded in the logs to the change table.

• Capture, to indicate that the logs are only retained so that the Capture program can write the updates to the change table. You cannot use the logs for forward recovery.

If logretain is set to "Recovery" or userexit is set to "Yes", the active log files will be retained and become online archive log files for use in roll-forward recovery. This is called log retention logging.

After logretain is set to "Recovery" or userexit is set to "Yes" (or both), you must make a full backup of the database. This state is indicated by the backup_pending flag parameter.

If logretain is set to "No" and userexit is set to "No", roll-forward recovery is not available for the database.

When logretain is set to "Capture", the Capture program calls the PRUNE LOGFILE command to delete log files when the Capture program completes. You should not set logretain to "Capture" if you want to perform roll-forward recovery on the database.

If logretain is set to "No" and userexit is set to "No", logs are not retained. In this situation, the database manager deletes all log files in the logpath directory (including online archive log files), allocates new active log files, and reverts to circular logging.