Informix Error -24116: Duplicate dbspace (<dbsname>) detected in CREATE DUPLICATE </dbsname> specification.
Cause and resolution
Duplicate dbspace (<dbsname>) detected in CREATE DUPLICATE </dbsname> specification.
A dbspace name occurs more than once in this statement. In a CREATE DUPLICATE you cannot specify a dbspace name more than once.
Rewrite the statement using only unique dbspace names. Remember that dbslices are expanded into their component dbspaces, excluding a dbspace that the original table uses.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24116 fires when a dbspace name occurs more than once in a CREATE DUPLICATE
statement — per the official guidance, dbslices are expanded into their component dbspaces
(excluding any the original table already uses) before this check runs.
- A dbspace name specified more than once in the
CREATE DUPLICATEstatement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Rewrite the statement using only unique dbspace names, per the official guidance, keeping in mind dbslices expand into their component dbspaces.
Examples
N/A
No specific triggering statement is documented beyond a repeated dbspace name.
Diagnostic Checks
- Check the dbspace names in the statement, after expanding any dbslices, for duplicates.
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. - -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, rather than repeated within the new specification.
A dbspace name occurred more than once in a CREATE DUPLICATE statement — use only unique
names.