Choosing storage characteristics

After initializing an LO-specification structure, you need to ensure that this structure contains the appropriate values for the storage characteristics you want the smart large object to have.

Then you pass this LO-specification structure to one of the smart-large-object creation functions (Table 1) so that the smart-large-object optimizer can obtain the storage characteristics to use for the new smart large object.

To choose storage characteristics for a new smart large object:

Use the system-specified storage characteristics as a basis for obtaining the storage characteristics of a smart large object.
The system-specified storage characteristics are the default storage characteristics for a smart large object.
Customize the storage characteristics.
You can override the system-specified storage characteristics with one of the following levels of the storage-characteristics hierarchy:
- 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 are called column-level storage characteristics.
- User-specified storage characteristics.
  Special storage characteristics that you define for this smart large object only are called user-specified storage characteristics.

Important: For most applications, use the system-specified values for the disk-storage information. Most DataBlade API modules need to ensure correct storage characteristics only for an sbspace name (the location of the smart large object) and for the smart-large-object attributes.