SBSPACENAME

onconfig.std value

None

if not present

0

range of values

Up to 128 characters. SBSPACENAME must be unique, begin with a letter or underscore, and contain only letters, digits, underscores, or $ characters.

takes effect

When shared memory is reinitialized

utilities

onspaces -c -S

refer to

The following material:

• Using onspaces to Create an Sbspace or Temporary Sbspace
• SBSPACETEMP
• SYSSBSPACENAME
• Sbspace Structure
• What is an sbspace, in the chapter on data storage in the IBM Informix Administrator's Guide
• Altering sbspace characteristics, in the chapter on managing data on disk in the IBM Informix Administrator's Guide
• Assigning a smart large object to an sbspace, in the section on the CREATE TABLE and ALTER TABLE statements, in the IBM Informix Guide to SQL: Syntax
• Creating an sbspace for Enterprise Replication usage, in the IBM Informix Dynamic Server Enterprise Replication Guide
• Using multirepresentational data, in the IBM Informix DataBlade API Programmer's Guide

SBSPACENAME specifies the name of the default sbspace. If your database tables include smart-large-object columns that do not explicitly specify a storage space, that data is stored in the sbspace that SBSPACENAME specifies.

You must create the default sbspace with the onspaces -c -S utility before you can use it. The database server validates the name of the default sbspace when one of the following occurs:

• You specify the default sbspace as the storage option for a CLOB or BLOB column in the PUT clause of the CREATE TABLE or ALTER TABLE statement.
• The database server attempts to write a smart large object to the default sbspace when no sbspace was specified for the column.
• You store multirepresentational data in the default sbspace.