Placement of Simple Large Objects

You can store simple large objects in either the same dbspace in which the table resides or in a blobspace.

A blobspace is a logical storage unit composed of one or more chunks that store only simple large objects (TEXT or BYTE data). For information on sbspaces, which store smart large objects (such as BLOB, CLOB, or multirepresentational data), see Parameters That Affect I/O for Smart Large Objects (IDS).

If you use a blobspace, you can store simple large objects on a separate disk from the table with which the data is associated. You can store simple large objects associated with different tables in the same blobspace.

You can create a blobspace with the following utilities:

• ON–Monitor (UNIX only)
• ISA
• onspaces

For details on these utilities, see the IBM Informix: Dynamic Server Administrator's Reference.

You assign simple large objects to a blobspace when you create the tables with which simple large objects are associated. For more information on the SQL statement CREATE TABLE, see the IBM Informix: Guide to SQL Syntax.

Simple large objects are not logged and do not pass through the buffer pool. However, frequency of checkpoints can affect applications that access TEXT or BYTE data. For more information, see LOGSIZE and LOGFILES.