Oninit
Talk to an expert →

Informix Error -12029: Smart Large Objects: Cannot delete SB_USERDATA_SLOT.

Cause and resolution

Smart Large Objects: Cannot delete SB_USERDATA_SLOT.

Cannot delete user data slot. First ensure that the chunk is accessible. If this error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12029 fires when a user data slot for a smart large object can't be deleted — per the official guidance.

  1. The chunk being inaccessible, per the official guidance — the named, likely cause.
Solutions / Resolution
  1. Ensure the chunk is accessible, per the official guidance.
  2. If this error recurs, note all circumstances and contact IBM Informix Technical Support, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond deleting a user data slot on an inaccessible chunk.

Diagnostic Checks
  1. Check the chunk's accessibility before retrying the user-data-slot delete.
Related Errors / Related Topics
  • -12026 — "Smart Large Objects: Cannot delete smart large object." The general form of this same class of delete failure.
  • -12027 — "Smart Large Objects: Cannot delete SB_LOHD_SLOT." The same class of delete failure, on the LO header slot rather than the user data slot.
  • -12028 — "Smart Large Objects: Cannot delete SB_LOMAP_SLOT." The same class of delete failure, on the extent map slot rather than the user data slot.

A user data slot couldn't be deleted, likely due to an inaccessible chunk — check chunk accessibility.