Work with storage characteristics

Storage characteristics tell the database server how to manage a smart large object. These characteristics include such areas as sizing, logging, locking, and open modes. You have the following options with respect to storage characteristics:

• Use the system-specified storage characteristics as a basis for obtaining the storage characteristics of a smart large object.
• Override the system defaults with one of the following:
  • Storage characteristics defined for a particular CLOB or BLOB column in which you want to store the smart large object
  • Storage characteristics that are unique to a particular CLOB or BLOB column called column-level storage characteristics
  • Special storage characteristics that you define for this smart large object only called user-specified storage characteristics

The database server uses a hierarchy, which the following figure shows, to obtain the storage characteristics for a new smart large object.

For a given storage characteristic, any value defined at the column level overrides the system-specified value, and any user-level value overrides the column-level value. You can specify storage characteristics at the three points shown in the following table.

When specified	How specified	For more information
When an sbspace is created	Options of onspaces utility	System-specified storage characteristics HCL OneDB™ Administrator's Guide
When a database table is created	Keywords in PUT clause of CREATE TABLE statement	HCL OneDB Guide to SQL: Syntax
When a smart large object is created	Create flags and methods in the ifxLobDescriptor class	Set create flags