Informix Error -12139: Smart Large Objects: Invalid option.

Reasons / Common Causes

-12139 fires when an invalid option is specified for changing sbspace characteristics — per the official guidance.

1. An attempt to change an sbspace characteristic that can't be changed (such as chunk offsets), per the official guidance — the direct, only cause.

Solutions / Resolution

1. Don't attempt to change characteristics that are fixed after creation, per the official guidance's implication — such as chunk offsets.

Examples

N/A

No specific triggering statement is documented beyond attempting to change a fixed characteristic.

Diagnostic Checks

1. Check which sbspace characteristic the operation is trying to change, and confirm it's one that's actually alterable.

Related Errors / Related Topics

• -12105 — "Smart Large Objects: An attempt to change the sbspace name was made." A related unchangeable-characteristic error, specific to the sbspace name field.

An invalid option was specified for changing an unchangeable sbspace characteristic — check which characteristics are actually alterable.