Informix Error -24117: Dbspace (<dbsname>) in CREATE DUPLICATE specification already </dbsname> exists in table.
Cause and resolution
Dbspace (<dbsname>) in CREATE DUPLICATE specification already </dbsname> exists in table.
The specified dbspace already contains a fragment of the table, so you cannot use the dbspace name in the CREATE DUPLICATE command.
Rewrite the statement to avoid specifying any dbspace that the original table already uses.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24117 fires when a CREATE DUPLICATE statement names a dbspace that already holds a
fragment of the original table — per the official guidance.
- A
CREATE DUPLICATEdbspace name already containing a fragment of the original table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Rewrite the statement to avoid any dbspace the original table already uses, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond naming a dbspace the original table already occupies.
Diagnostic Checks
- Check the original table's existing fragment dbspaces, and confirm none of them
appear in the
CREATE DUPLICATEspecification.
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. - -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 dbspace repeated within the new specification itself, rather than already used by the original table.
A CREATE DUPLICATE statement named a dbspace the original table already uses — avoid it.