Informix Error -12096: Smart Large Objects: alter: New size limit < number of bytes in the smart large object.
Cause and resolution
Smart Large Objects: alter: New size limit < number of bytes in the smart large object.
The application programmer specified an invalid value for the size limit. The value must be greater than or equal to the current number of bytes in the smart large object. If the new size limit is less than the current number of bytes in the smart large object, do not alter the value in the header.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12096 fires when an ALTER sets a new size limit smaller than the object's current byte
count — per the official guidance.
- A new size-limit value less than the smart large object's current number of bytes, per the official guidance — the direct, only cause.
Solutions / Resolution
- Set the new size limit greater than or equal to the current number of bytes, per the official guidance.
- If the new size limit is genuinely meant to be smaller, don't alter the header value, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a shrinking size limit below current usage.
Diagnostic Checks
- Check the object's current byte count, and confirm the new size limit is at least that large.
Related Errors / Related Topics
- -12105 — "Smart Large Objects: An attempt to change the sbspace name was made." A related alter-operation restriction, on the sbspace name field rather than the size limit.
An ALTER's new size limit was smaller than the object's current byte count — set it at or above the current size.