Informix Error -21515: Cannot perform online index build for attached indices
Cause and resolution
Cannot perform online index build for attached indices
Online index build is allowed only for detached and semi-detached indices. It is not supported for attached index builds.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-21515 fires when an online index build is requested for an attached index — per the official guidance, online index build is only allowed for detached and semi-detached indices.
- Requesting an online index build for an attached index, per the official guidance — the direct, only cause.
Solutions / Resolution
- Detach the index, or use a non-online build for attached indices, per the official guidance's implication — online build isn't supported for attached indices.
Examples
N/A
No specific triggering statement is documented beyond requesting an online build on an attached index.
Diagnostic Checks
- Check whether the target index is attached, detached, or semi-detached, and use a non-online build if it's attached.
Related Errors / Related Topics
- -21522 — "No online index build possible." A related online-index-build restriction, general to the scenario rather than specifically attached indices.
An online index build was requested for an attached index, which isn't supported — only detached/semi-detached indices allow online build.