Informix Error -2811: The temporary table table-name could not be opened for writing.
Cause and resolution
The temporary table table-name could not be opened for writing.
The application is attempting to create a temporary table in the database or some other temporary file but received an error code from the database server. The most probable cause is a lack of disk space. Look for other error messages, including operating-system messages, that might give more information.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-2811 fires when an application can't create a temporary table (or the server returns an error attempting to) — per the official guidance, the primary cause is typically insufficient disk space.
- Insufficient disk space, per the official guidance — the primary, named cause.
Solutions / Resolution
- Review additional error messages, including operating-system messages, per the official guidance, for more diagnostic detail.
- Check available disk space as the first, most likely check.
Examples
Checking disk space
$ df -h
Diagnostic Checks
- Check available disk space first, then review any accompanying OS-level error messages.
Related Errors / Related Topics
- -2812 — "The temporary table table-name could not be read." A related temporary-table error, about reading from an already-created table rather than creating it.
A temporary table couldn't be created, most likely from insufficient disk space — check disk space and accompanying error messages.