Informix Error -47105: Dbspace has already been selected as part of the strategy.

Cause and resolution

Dbspace has already been selected as part of the strategy.

You cannot use the same dbspace more than once in a fragmentation strategy. The dbspace you selected is already part of the strategy. Select another dbspace from the current list.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-47105 fires in the interactive ALTER TABLE menu when the same dbspace is selected more than once in a fragmentation strategy — per the official guidance.

The selected dbspace already being part of the strategy, per the official guidance — the direct, only cause.

Solutions / Resolution

Select a different dbspace from the current list, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond this menu-driven duplicate-dbspace restriction.

Diagnostic Checks

Check which dbspaces are already part of the strategy, and select one not yet included.

Related Errors / Related Topics

-47106 — "Table has already been selected as part of the attaching strategy." The same duplicate-selection restriction, for a table rather than a dbspace.

The selected dbspace is already part of the fragmentation strategy — choose a different one.