Informix Error -12042: Smart Large Objects: Size of page is too big.
Cause and resolution
Smart Large Objects: Size of page is too big.
The page size specified during an sbspace creation operation is too big. Specify a page size that is less than the platform-dependent maximum asynchronous I/O size or is greater than the subsystem page-size limitation for the smart large object.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12042 fires when an sbspace creation's page size is too big — per the official guidance.
- A page size greater than the platform-dependent maximum asynchronous I/O size, or greater than the subsystem's page-size limitation, per the official guidance — the direct, only cause.
Solutions / Resolution
- Specify a page size within the platform's maximum asynchronous I/O size and the subsystem's page-size limitation, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an over-large page size.
Diagnostic Checks
- Check the platform's maximum asynchronous I/O size and the smart-large-object subsystem's page-size limit, and reduce the requested page size to fit both.
Related Errors / Related Topics
- -12023 — "Smart Large Objects: chunk size is too small." A related sbspace-creation sizing error, on chunk size (too small) rather than page size (too big).
The sbspace's requested page size exceeded the platform or subsystem limit — reduce it.