Informix Error -12112: Smart Large Objects: Conversion from using buffers to light IO not allowed.

Reasons / Common Causes

-12112 fires when an application tries to switch a smart large object's buffering mode from buffered I/O to lightweight I/O — per the official guidance.

1. An attempt to change the object's buffering mode from buffered to lightweight I/O, per the official guidance — the direct, only cause; this conversion isn't currently allowed.

Solutions / Resolution

1. Don't attempt this conversion — per the official guidance, it isn't currently supported. Close and reopen the object with the desired I/O mode from the start instead.

Examples

N/A

No specific triggering statement is documented beyond attempting the mode conversion.

Diagnostic Checks

1. Check whether the application is attempting to change buffering mode mid-session, and instead reopen the object with the intended mode.

Related Errors / Related Topics

• -12111 — "Smart Large Objects: Attempt to write to a smart large object without closing light IO scan." A related lightweight-I/O restriction, on writing during an open scan rather than switching buffering modes.

Switching a smart large object's buffering mode from buffered to lightweight I/O isn't allowed — reopen it with the desired mode instead.