Oninit
Talk to an expert →

Informix Error -12057: Smart Large Objects: Cannot open sbspace description partition.

Cause and resolution

Smart Large Objects: Cannot open sbspace description partition.

The smart-large-object space is probably down, or an attempt was made to open a space that should have been a smart-large-object space but was not.

Ensure that the first chunk of the smart-large-object space is up. Also ensure that an application program is not attempting to perform TEXT or BYTE operations to a smart-large-object space.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12057 fires when the sbspace description partition can't be opened — per the official guidance.

  1. The smart-large-object space's first chunk being down, per the official guidance — the first named case.
  2. An attempt to open a space as a smart-large-object space when it isn't one, per the official guidance — the second named case.
Solutions / Resolution
  1. Ensure the first chunk of the smart-large-object space is up, per the official guidance.
  2. Ensure the application isn't performing TEXT/BYTE operations against a smart-large-object space, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a down first chunk or a space-type mismatch.

Diagnostic Checks
  1. Check the first chunk's online status, and confirm the target space is actually a smart-large-object space rather than a blobspace being accessed via TEXT/BYTE.
Related Errors / Related Topics
  • -12056 — "Smart Large Objects: Cannot open sbspace." A related, more general sbspace- open failure.

The sbspace description partition couldn't be opened, likely due to a down first chunk or a space-type mismatch — check both.