Informix Error -21532: Defragment: The partition is in the wrong state or an incompatible type
Cause and resolution
Defragment: The partition is in the wrong state or an incompatible type
ACTION If a conflicting action is occurring on the partition, run defragmentation later. Otherwise the partition is a type that cannot be defragmented. See the IBM Informix Data Server Administrator's Reference for information on defragmentation restrictions.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-21532 fires when the target partition is in a state or of a type that defragmentation doesn't support — per the official guidance.
- A conflicting action currently occurring on the partition, per the official guidance — the first named case.
- A partition type that can't be defragmented, per the official guidance — the second named case; see the IBM Informix Data Server Administrator's Reference for defragmentation restrictions.
Solutions / Resolution
- If a conflicting action is occurring, run defragmentation again later, per the official guidance.
- If the partition's type doesn't support defragmentation, don't defragment it — check the Administrator's Reference for the type restrictions, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a state/type-incompatible partition.
Diagnostic Checks
- Check for a conflicting operation on the partition, and check its type against the documented defragmentation restrictions.
Related Errors / Related Topics
- -21531 — "Defragment: A partition that contains a partition header page table cannot be defragmented." A specific case of this restriction, for partition header page tables.
- -21533 — "Defragment: A defragmentation task is already in progress on this dbspace." A related restriction, on a concurrent defragment task rather than partition state/type.
The partition's state or type doesn't support defragmentation — retry later if a conflicting action is running, or check type restrictions.