Informix Error -12105: Smart Large Objects: An attempt to change the sbspace name was made.

Cause and resolution

Smart Large Objects: An attempt to change the sbspace name was made.

In an alter operation, an attempt was made to change the name of the sbspace for the smart large object. You cannot change an sbspace name with the alter operation.

Re-execute the alter operation with a NULL sbspace name in the LO-specification structure or the name of the sbspace in which the smart large object currently resides.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12105 fires when an ALTER operation tries to change the sbspace name a smart large object resides in — per the official guidance.

An alter operation specifying a different sbspace name than the object's current one, per the official guidance — the direct, only cause; this field can't be changed via alter.

Solutions / Resolution

Re-execute the alter operation with a NULL sbspace name in the LO-specification structure, per the official guidance, or
Use the name of the sbspace the object currently resides in, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond attempting to rename the sbspace via alter.

Diagnostic Checks

Check the sbspace-name field in the alter's LO-specification structure, and set it to NULL or the object's current sbspace name.

Related Errors / Related Topics

-12096 — "Smart Large Objects: alter: New size limit < number of bytes in the smart large object." A related alter-operation restriction, on the size-limit field rather than the sbspace name.

An ALTER tried to change the object's sbspace name, which isn't allowed — set the field to NULL or the current sbspace name.