Informix Error -47109: A Dbspace is required if a position is defined.
Cause and resolution
A Dbspace is required if a position is defined.
You have specified a dbspace as part of your attaching table strategy. This action indicates that you wish to position the attaching table before or after a dbspace that is part of the fragmentation strategy being attached to. You must define a before or after position.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47109 fires in the interactive ALTER TABLE menu when a before/after position is
specified for an attaching table strategy without also specifying a dbspace — per the
official guidance.
- A before/after position defined without an accompanying dbspace, per the official guidance — the direct, only cause.
Solutions / Resolution
- Define a before or after position along with the dbspace, per the official guidance, to position the attaching table relative to it.
Examples
N/A
No specific triggering statement is documented beyond this menu-driven attach-positioning restriction.
Diagnostic Checks
- Check that both a dbspace and a before/after position are specified together for the attaching table.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -47109 in this set yet.
A before/after position was specified without a dbspace to position relative to — specify both together.