Informix Error -21539: Defragment: You can't run this command on catalog/pseudo/temp tables

Reasons / Common Causes

-21539 fires when defragmentation targets a catalog, pseudo, or temp table — per the official guidance, these table kinds aren't eligible.

1. The target being a catalog, pseudo, or temp table, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Run defragment on a regular table/partition instead, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond targeting a catalog/pseudo/temp table.

Diagnostic Checks

1. Check whether the target table is a catalog, pseudo, or temp table, and choose a regular table/partition instead.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -21539 in this set yet.

Defragmentation was attempted on a catalog/pseudo/temp table, which isn't eligible — run it on a regular table/partition.