Informix Error -32406: Value must be greater than zero.
Cause and resolution
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.
- An extent size of zero or less specified while creating or altering a table, per the official guidance — the direct, only cause.
Solutions / Resolution
- 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
- 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.