Informix Error -19836: Extent size is too large. Maximum size of an extent is %sk.

Cause and resolution

Extent size is too large. Maximum size of an extent is %sk.

The maximum size specified for a disk extent (either the EXTENT SIZE or the NEXT SIZE clause) is 16 MB pages on 9.40 and the maximum size of a chunk on 9.3x and lower.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19836 fires when an EXTENT SIZE/NEXT SIZE clause exceeds the maximum allowed extent size — per the official guidance: 16 MB pages on 9.40 and later, or the maximum chunk size on 9.3x and earlier.

An EXTENT SIZE/NEXT SIZE value exceeding the platform/version's maximum, per the official guidance — the direct, only cause.

Solutions / Resolution

Reduce the EXTENT SIZE/NEXT SIZE value below the reported maximum, per the official guidance.

Examples

An oversized extent

CREATE TABLE mytab (id INT) EXTENT SIZE 999999999;

Corrected

CREATE TABLE mytab (id INT) EXTENT SIZE 1000;

Diagnostic Checks

Check the EXTENT SIZE/NEXT SIZE value against the reported maximum (in the error message itself).

Related Errors / Related Topics

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

An EXTENT SIZE/NEXT SIZE value exceeds the platform maximum — reduce it.