Informix Error -23525: CM error: All available IDs for fragmented tables are in use.

Cause and resolution

CM error: All available IDs for fragmented tables are in use.

A request to create a fragmented table failed because the maximum allowed number is already in use.

Drop one or more obsolete fragmented tables and resubmit the query.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-23525 fires when creating a fragmented table while the maximum allowed number of fragmented-table IDs is already in use — per the official guidance.

The maximum number of fragmented-table IDs already in use, per the official guidance — the direct, only cause.

Solutions / Resolution

Drop one or more obsolete fragmented tables and resubmit the query, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond reaching the fragmented-table ID maximum.

Diagnostic Checks

Check the current fragmented-table count against the configured maximum, and drop obsolete ones if at capacity.

Related Errors / Related Topics

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

All available fragmented-table IDs were in use — drop obsolete fragmented tables before creating more.