Oninit
Talk to an expert →

Informix Error -12110: Smart Large Objects: Could not find suitable size extent.

Cause and resolution

Smart Large Objects: Could not find suitable size extent.

Server could not find a suitable size extent for a smart large object. A write request might not be complete.

Delete some smart large objects or add a chunk to the sbspace.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12110 fires when the server can't find a suitably sized extent for a smart large object — per the official guidance.

  1. No extent of a suitable size available for the write, per the official guidance — the direct, only cause; the write request might not complete.
Solutions / Resolution
  1. Delete some smart large objects, per the official guidance, or
  2. Add a chunk to the sbspace, per the official guidance.
Examples
Adding a chunk to an sbspace
$ onspaces -a sbspace_name -p /path/to/chunk -o 0 -s 500000
Diagnostic Checks
  1. Check the sbspace's free space and fragmentation, and either delete objects or add a chunk.
Related Errors / Related Topics
  • -12031 — "Smart Large Objects: Sbspace is full." A related storage-exhaustion error, general insufficient space rather than specifically no suitably sized extent.

No suitably sized extent was available for a write — delete objects or add a chunk via onspaces.