Oninit
Talk to an expert →

Informix Error -12031: Smart Large Objects: Sbspace is full.

Cause and resolution

Smart Large Objects: Sbspace is full.

The user data area or areas have insufficient storage for a write request. Delete some smart large objects or add a chunk to the sbspace.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12031 fires when the sbspace's user data area has insufficient storage for a write request — per the official guidance.

  1. The sbspace's user data area(s) having insufficient free storage, per the official guidance — the direct, only cause.
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 either delete smart large objects or add a chunk.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -12031 in this set yet.

The sbspace ran out of storage for a write — delete objects or add a chunk via onspaces.