Informix Error -12087: Smart Large Objects: alter: attempt to change physical characteristics of a smart large object in sb_alter.
Cause and resolution
Smart Large Objects: alter: attempt to change physical characteristics of a smart large object in sb_alter.
The database administrator attempted to perform an alter operation on a smart-large-object column that requires physical reorganization or relocation of the smart large objects.
Do not attempt to reorganize smart large objects physically. As an alternative to physical reorganization, try using the LOCopy function to copy smart large objects to a new location with different physical attributes.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12087 fires when an ALTER attempts to change a smart-large-object column's physical
characteristics in a way requiring reorganization or relocation — per the official
guidance.
- An alter operation requiring physical reorganization/relocation of existing smart large objects, per the official guidance — the direct, only cause; this isn't supported.
Solutions / Resolution
- Don't attempt to physically reorganize smart large objects via
ALTER, per the official guidance. - Use the
LOCopyfunction to copy smart large objects to a new location with different physical attributes, per the official guidance, as an alternative.
Examples
N/A
No specific triggering statement is documented beyond an alter requiring physical reorganization.
Diagnostic Checks
- Check whether the intended
ALTERrequires physically moving existing smart large objects, and useLOCopyinstead if so.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -12087 in this set yet.
An ALTER attempted to physically reorganize existing smart large objects, which isn't
supported — use LOCopy to relocate them instead.