Informix Error -25825: Cannot specify remainder fragment for interval fragmentation.
Cause and resolution
Cannot specify remainder fragment for interval fragmentation.
Interval fragmentated tabl or index cannot have remainder fragment. Rewrite the statement to remove the remainder fragment specification.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25825 fires when an interval fragmentation scheme includes a REMAINDER
fragment — per the official guidance, interval-fragmented tables/indexes can't have one.
- A
REMAINDERfragment specified for interval fragmentation, per the official guidance — the direct, only cause.
Solutions / Resolution
- Remove the remainder fragment specification, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a REMAINDER fragment in an interval
scheme.
Diagnostic Checks
- Check the fragmentation scheme for a
REMAINDERfragment, and remove it if the scheme is interval-based.
Related Errors / Related Topics
- -25826 — "Cannot specify more than one null fragment for interval or list fragmentation." A related fragment-count restriction, on null fragments rather than remainder fragments.
An interval fragmentation scheme specified a REMAINDER fragment, which isn't allowed —
remove it.