Informix Error -12224: The partition needs to be archived.
Cause and resolution
The partition needs to be archived.
If the table type is altered from non logging to logging, perform a backup before you use the table in a transaction or modify data within the table. Otherwise the table may not be fully recovered if the server crashes.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12224 fires as a warning that a table converted from non-logging to logging needs a backup — per the official guidance.
- A table type altered from non-logging to logging without a subsequent backup, per the official guidance — the direct, only cause; without a backup, the table may not be fully recoverable if the server crashes.
Solutions / Resolution
- Perform a backup before using the table in a transaction or modifying its data, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond altering a table to logging without a follow-up backup.
Diagnostic Checks
- Check whether a backup has run since the table was altered to logging, and perform one before further use.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -12224 in this set yet.
A table was altered from non-logging to logging without a subsequent backup — back it up before further use.