Informix Error -12113: Smart Large Objects: Attempt to convert from using light IO to buffers while LO is open.
Cause and resolution
Smart Large Objects: Attempt to convert from using light IO to buffers while LO is open.
The user tried to alter a smart large object with either ifx_lo_alter() (ESQL/C) or mi_lo_alter() (DAPI) while some instances of the smart large object are currently open.
Close all open instances of the smart large object before altering the buffering mode with ifx_lo_alter() or mi_lo_alter().
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12113 fires when ifx_lo_alter()/mi_lo_alter() is called to change buffering mode
while instances of the object are open — per the official guidance.
- Instances of the smart large object still open when the alter call is made, per the official guidance — the direct, only cause.
Solutions / Resolution
- Close all open instances of the smart large object before altering its buffering mode, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond altering buffering mode with open instances.
Diagnostic Checks
- Check for open instances of the object, and close them all before calling
ifx_lo_alter()/mi_lo_alter().
Related Errors / Related Topics
- -12112 — "Smart Large Objects: Conversion from using buffers to light IO not allowed." A related buffering-mode restriction, on the reverse conversion direction, which isn't allowed at all.
An alter call tried to change buffering mode with open instances of the object — close them all first.