Informix Error -47106: Table has already been selected as part of the attaching strategy.
Cause and resolution
Table has already been selected as part of the attaching strategy.
A table can be attached to a fragmentation strategy only once. The table that you selected is already part of the fragmentation strategy. Select another table from the current list.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47106 fires in the interactive ALTER TABLE menu when the same table is selected for
attachment more than once — per the official guidance, a table can only be attached to a
fragmentation strategy once.
- The selected table already being part of the fragmentation strategy, per the official guidance — the direct, only cause.
Solutions / Resolution
- Select a different table from the current list, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond this menu-driven duplicate-table restriction.
Diagnostic Checks
- Check which tables are already part of the attaching strategy, and select one not yet included.
Related Errors / Related Topics
- -47105 — "Dbspace has already been selected as part of the strategy." The same duplicate-selection restriction, for a dbspace rather than a table.
The selected table is already part of the attaching fragmentation strategy — choose a different one.