Oninit
Talk to an expert →

Informix Error -12053: Smart Large Objects: No sbspace number specified.

Cause and resolution

Smart Large Objects: No sbspace number specified.

No default sbspace was found, and the caller has not specified an sbspace to use.

Either specify the smart-large-object space name in the smart-large-object function call or set the SBSPACENAME onconfig file parameter to the name of a valid smart-large-object space.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12053 fires when a smart-large-object create call has no sbspace to use — per the official guidance.

  1. No default sbspace found, and no sbspace specified by the caller, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Specify the smart-large-object space name in the create function call, per the official guidance, or
  2. Set the SBSPACENAME onconfig parameter to a valid smart-large-object space name, per the official guidance.
Examples
Setting SBSPACENAME in onconfig
SBSPACENAME sbspace1
Diagnostic Checks
  1. Check whether SBSPACENAME is set in onconfig, and check whether the create call itself names an sbspace.
Related Errors / Related Topics
  • -12036 — "Smart Large Objects: Invalid sbspace name." A related sbspace-selection error, about naming a nonexistent sbspace rather than naming none at all.

No default sbspace was configured and none was specified — set SBSPACENAME in onconfig or name one in the call.