Informix Error -25826: Cannot specify more than one null fragment for interval or list fragmentation.
Cause and resolution
Cannot specify more than one null fragment for interval or list fragmentation.
Interval or list fragmentated table or index cannot have more than one null fragment. Rewrite the statement to remove the null fragment specification.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25826 fires when an interval/list fragmentation scheme includes more than one null fragment — per the official guidance, at most one is allowed.
- More than one null fragment specified, per the official guidance — the direct, only cause.
Solutions / Resolution
- Remove the extra null fragment specification(s), per the official guidance, keeping only one.
Examples
N/A
No specific triggering statement is documented beyond multiple null fragments.
Diagnostic Checks
- Check the fragmentation scheme for more than one null-only fragment, and remove the extras.
Related Errors / Related Topics
- -25825 — "Cannot specify remainder fragment for interval fragmentation." A related fragment-count restriction, on remainder fragments rather than null fragments.
More than one null fragment was specified for interval/list fragmentation — keep only one.