Informix Error -9814: Invalid default sbspace name (sbspace_name)).
Cause and resolution
Invalid default sbspace name (sbspace_name)).
The database server is trying to create a smart large object in the default sbspace, but the sbspace does not exist. Check that the SBSPACENAME parameter in the ONCONFIG file is the name of an existing sbspace. If necessary, the database server administrator can create an sbspace using the onspaces command.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9814 fires when the server tries to create a smart large object in the default sbspace, but that sbspace doesn't exist — per the official guidance.
- SBSPACENAME in ONCONFIG naming an sbspace that hasn't been created, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check that SBSPACENAME in ONCONFIG names an existing sbspace, per the official guidance.
- If necessary, have the database server administrator create the sbspace with
onspaces, per the official guidance.
Examples
Creating the default sbspace
$ onspaces -c -S sbspace1 -p /path/to/chunk -o 0 -s 100000
Diagnostic Checks
- Check ONCONFIG's SBSPACENAME value against
onstat -d's list of existing sbspaces, and create the sbspace if missing.
Related Errors / Related Topics
- -9820 — "SQL SBLOB error: no such sbspace." A related sbspace-existence error, for an sbspace named directly in a statement (e.g. a PUT clause) rather than the default SBSPACENAME.
The default sbspace named by SBSPACENAME doesn't exist — create it with onspaces.