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.

About this task

Then you pass this LO-specification structure to one of the smart-large-object creation functions (Smart-large-object creation functions) 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:

Procedure

  1. 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.

  2. 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.

Results

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.