Informix Error -24114: Number of dbspace lists does not match number of fragments in table.
Cause and resolution
Number of dbspace lists does not match number of fragments in table.
In the CREATE DUPLICATE statement, the number of supplied dbspace lists must match the number of fragments in the original table.
Rewrite the CREATE DUPLICATE statement and specify a list of dbspaces for each original fragment of the table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24114 fires when a CREATE DUPLICATE statement supplies a different number of dbspace
lists than the original table has fragments — per the official guidance.
- A
CREATE DUPLICATEstatement's dbspace-list count not matching the original table's fragment count, per the official guidance — the direct, only cause.
Solutions / Resolution
- Rewrite the statement to specify a dbspace list for each of the original table's fragments, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a dbspace-list-count mismatch.
Diagnostic Checks
- Count the original table's fragments and the
CREATE DUPLICATEstatement's dbspace lists, and confirm they match.
Related Errors / Related Topics
- -24113 — "Table (
) is not a duplicated table." A related CREATE DUPLICATEerror, on targeting a non-duplicated table rather than a dbspace-list count mismatch. - -24115 — "Number of dbspaces per dbspace list must be identical." A related
CREATE DUPLICATEerror, on per-list dbspace count consistency. - -24116 — "Duplicate dbspace (
) detected in CREATE DUPLICATE specification." A related CREATE DUPLICATEerror, on a repeated dbspace name. - -24117 — "Dbspace (
) in CREATE DUPLICATE specification already exists in table." A related CREATE DUPLICATEerror, on a dbspace already used by the original table's fragments.
A CREATE DUPLICATE statement's dbspace-list count didn't match the original table's
fragment count — supply one list per fragment.