Oninit
Talk to an expert →

Informix Error -9827: The sbspace specified by the SYSSBSPACENAME configuration parameter does not exist (syssbspace_name).

Cause and resolution

The sbspace specified by the SYSSBSPACENAME configuration parameter does not exist (syssbspace_name).

The database server failed to create a smart large object in the sbspace that is specified by the SYSSBSPACENAME configuration parameter because the sbspace does not exist. Check that the value of the SYSSBSPACENAME configuration 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 and update the value of the SYSSBSPACENAME configuration parameter in the onconfig file.

The UPDATE STATISTICS operation might require an existing sbspace, which is specified by the SYSSBSPACENAME configuration parameter.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9827 fires when the server tries to create a smart large object in the sbspace named by SYSSBSPACENAME, but that sbspace doesn't exist — per the official guidance.

  1. SYSSBSPACENAME in ONCONFIG naming an sbspace that hasn't been created, per the official guidance — the direct, only cause. UPDATE STATISTICS may specifically require this sbspace to exist, per the official guidance.
Solutions / Resolution
  1. Check that SYSSBSPACENAME in the ONCONFIG file names an existing sbspace, per the official guidance.
  2. If necessary, have the database server administrator create the sbspace with onspaces and update SYSSBSPACENAME in ONCONFIG, per the official guidance.
Examples
Creating the sbspace named by SYSSBSPACENAME
$ onspaces -c -S syssbspace1 -p /path/to/chunk -o 0 -s 100000
Diagnostic Checks
  1. Check ONCONFIG's SYSSBSPACENAME value against onstat -d's list of existing sbspaces, and create it if missing.
Related Errors / Related Topics
  • -9814 — "Invalid default sbspace name (sbspace_name))." The same class of missing- sbspace error, for SBSPACENAME rather than SYSSBSPACENAME.

The sbspace named by SYSSBSPACENAME doesn't exist — create it with onspaces and update ONCONFIG.