Informix Error -47107: An Alter Table option has already been altered.
Cause and resolution
An Alter Table option has already been altered.
You can execute only one menu option in an ALTER FRAGMENT menu session, and it cannot be applied to the current strategy more than once. For example, you can add only one dbspace to a round-robin strategy, and you cannot delete a dbspace during the same ALTER TABLE session.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47107 fires in the interactive ALTER FRAGMENT menu when the same option is applied to
the current strategy more than once in a single session — per the official guidance, only
one menu option can be executed per ALTER FRAGMENT session.
- The same menu option (e.g. adding a dbspace) attempted twice in one session, per the official guidance — the direct, only cause.
Solutions / Resolution
- No documented workaround within the same session — per the official guidance,
perform only one option per
ALTER FRAGMENTsession (e.g. add one dbspace to a round-robin strategy; deleting a dbspace requires a separate session).
Examples
N/A
No specific triggering statement is documented beyond this menu-driven single-option restriction.
Diagnostic Checks
- Check whether an option was already applied in this
ALTER FRAGMENTsession, and start a new session for any additional change.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -47107 in this set yet.
Only one ALTER FRAGMENT menu option can be applied per session — start a new session for
each additional change.