Informix Error -24115: Number of dbspaces per dbspace list must be identical.
Cause and resolution
Number of dbspaces per dbspace list must be identical.
In the CREATE DUPLICATE statement, the number of dbspaces in each dbspace list must be the same.
Rewrite the statement to satisfy this criterion. Remember that dbslices are expanded into their component dbspaces, excluding a dbspace that the original table uses.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24115 fires when a CREATE DUPLICATE statement's dbspace lists don't all contain the same
number of dbspaces — per the official guidance, dbslices are expanded into their component
dbspaces (excluding any the original table already uses) before this count is checked.
- A
CREATE DUPLICATEstatement's dbspace lists having differing dbspace counts, per the official guidance — the direct, only cause.
Solutions / Resolution
- Rewrite the statement so every dbspace list has the same number of dbspaces, per the official guidance, keeping in mind dbslices expand into their component dbspaces.
Examples
N/A
No specific triggering statement is documented beyond mismatched per-list dbspace counts.
Diagnostic Checks
- Count the dbspaces in each dbspace list, expanding any dbslices first, and confirm they're all equal.
Related Errors / Related Topics
- -24113 — "Table (
) is not a duplicated table." A related CREATE DUPLICATEerror, on targeting a non-duplicated table. - -24114 — "Number of dbspace lists does not match number of fragments in table." A
related
CREATE DUPLICATEerror, on the overall list count rather than per-list 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 lists had differing dbspace counts — make every
list the same size.