Informix Error -43336: (-43336) Logical Logs cannot be backed-up because the database server is dismissing the logical logs.
Cause and resolution
(-43336) Logical Logs cannot be backed-up because the database server is dismissing the logical logs.
If the database server was started with an ONCONFIG file containing the LTAPEDEV parameter with a value of '/dev/null' (UNIX), 'NUL', (Windows) or blank,logical log back up cannot be performed. These special values indicate that log backups are not desired. Data in this logical log cannot be restored in the future. Only whole-system backups are allowed.
ACTION If logical log restores are desired, then set the LTAPEDEV configuration parameter value to something other than '/dev/null' (UNIX), 'NUL' (Windows) or blank.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-43336 fires when LTAPEDEV is configured to dismiss (discard) logical logs — per the
official guidance.
LTAPEDEVset to/dev/null(UNIX),NUL(Windows), or blank, per the official guidance — these special values mean log backups aren't wanted; only whole-system backups are allowed, and this logical log's data can't be restored later.
Solutions / Resolution
- Set
LTAPEDEVinONCONFIGto a real value, per the official guidance, if logical log restores are desired.
Examples
Enabling logical log backup
# In $ONCONFIG — before (logs dismissed)
LTAPEDEV /dev/null
# After (logs retained)
LTAPEDEV /dev/ltape
Diagnostic Checks
- Check
LTAPEDEV's configured value, and set it to a real device/path if logical log restores are needed.
Related Errors / Related Topics
- -43338 — "(-43338) Non whole-system backups are not allowed if the database server
is dismissing logical logs." A related consequence of the same
LTAPEDEVdismiss setting, restricting the backup type instead of the log backup itself.
LTAPEDEV is set to dismiss logical logs, so they can't be backed up — set it to a real
value if logical log restores are needed.