Informix Error -12111: Smart Large Objects: Attempt to write to a smart large object without closing light IO scan.
Cause and resolution
Smart Large Objects: Attempt to write to a smart large object without closing light IO scan.
The user tried to write to a smart large object that is currently opened for a lightweight I/O scan.
Close the open smart large object and open it again (without lightweight I/O) before you write to the smart large object.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12111 fires when a write is attempted on a smart large object still open for a lightweight I/O scan — per the official guidance.
- The object currently open for a lightweight I/O scan, per the official guidance — the direct, only cause.
Solutions / Resolution
- Close the open smart large object and reopen it without lightweight I/O, per the official guidance, before writing.
Examples
N/A
No specific triggering statement is documented beyond writing during an active light-IO scan.
Diagnostic Checks
- Check whether the object is currently open for a lightweight I/O scan, and close and reopen it in a writable mode before writing.
Related Errors / Related Topics
- -12112 — "Smart Large Objects: Conversion from using buffers to light IO not allowed." A related lightweight-I/O restriction, on switching buffering modes rather than writing during a scan.
A write was attempted while the object was open for a lightweight I/O scan — close and reopen it first.