Oninit
Talk to an expert →

Informix Error -32406

-32406 Value must be greater than zero.

You specified an extent size less than or equal to zero when you created or altered a table. Specify an extent size greater than zero.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32406 fires when a table's specified extent size is zero or negative — per the official guidance.

  1. An extent size of zero or less specified while creating or altering a table, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Specify an extent size greater than zero, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a non-positive extent size.

Diagnostic Checks
  1. Check the extent-size value specified, and correct it to a positive number.
Related Errors / Related Topics
  • -32401 — "The initial extent size cannot be changed when altering a table." A related extent-size error, on the initial-extent size being immutable rather than the value itself being invalid.

A table's specified extent size was zero or negative — specify a positive value.