Oninit
Talk to an expert →

Informix Error -9820: SQL SBLOB error: no such sbspace.

Cause and resolution

SQL SBLOB error: no such sbspace.

The most likely problem is that an operation specifies an sbspace by name (for example, in the PUT clause of a CREATE TABLE statement), but that sbspace has not been created.

You can run the onstat utility with the -d option to see the names of sbspaces created. Ask the database server administrator about creating a new sbspace.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9820 fires when an operation names an sbspace that hasn't been created — per the official guidance; most likely a PUT clause of a CREATE TABLE statement naming a nonexistent sbspace.

  1. A named sbspace that hasn't been created, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Run onstat -d to see the names of sbspaces that exist, per the official guidance.
  2. Ask the database server administrator about creating a new sbspace, per the official guidance, if the required one doesn't exist.
Examples
Checking existing sbspaces
$ onstat -d
Diagnostic Checks
  1. Check onstat -d's sbspace list against the name used in the statement, and create the sbspace if missing, or correct the name.
Related Errors / Related Topics
  • -9814 — "Invalid default sbspace name (sbspace_name))." A related sbspace-existence error, for the default sbspace named by SBSPACENAME rather than one named directly in a statement.

An sbspace named in the statement (e.g. a PUT clause) doesn't exist — check onstat -d and create it, or correct the name.