Informix Error -12089: Smart Large Objects: create: size limit of smart large object < -1.

Cause and resolution

Smart Large Objects: create: size limit of smart large object < -1.

The application programmer specified an invalid value for the size limit of the smart large object. If the number of bytes in a smart large object is unknown, set the estimated-number-of-bytes field to -1 or call ifx_lo_def_create_spec or the equivalent mi function and then leave this field alone.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12089 fires when a smart-large-object create specification's size-limit field is invalid — per the official guidance.

A size-limit value less than -1, per the official guidance — the direct, only cause.

Solutions / Resolution

Set the estimated-number-of-bytes field to -1 if the size is unknown, per the official guidance, or
Call ifx_lo_def_create_spec (or the equivalent mi function) and leave the field alone, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond an invalid size-limit value.

Diagnostic Checks

Check the size-limit field in the create specification, and set it to -1 or leave it at the default from ifx_lo_def_create_spec.

Related Errors / Related Topics

-12088 — "Smart Large Objects: create: number of estimate bytes < -1." The same class of invalid create-specification value, for the estimated-bytes field.
-12095 — "Smart Large Objects: create: Invalid Ext. size." The same class of invalid create-specification value, for the extent size field.

The size-limit field in a create specification was less than -1 — set it to -1 or leave the ifx_lo_def_create_spec default.