The ifx_lo_specset_extsz() function

The ifx_lo_specset_extsz() function sets the allocation extent size for a smart large object.

Syntax

mint ifx_lo_specset_extsz(LO_spec, extsz)
   ifx_lo_create_spec_t *LO_spec;
   mint extsz;

LO_spec: A pointer to the LO-specification structure in which to save the extent size.
extsz: An integer value for the size of the allocation extent of a smart large object.

Usage

The extsz value specifies the size of the allocation extents to be allocated for the smart large object when the database server writes beyond the end of the current extent. This value overrides the estimate that HCL OneDB™ generates for how large an extent is to be. For more information about the allocation extent, see Disk-storage information in the LO-specification structure.

If you do not specify an extsz value when you create a smart large object, HCL OneDB attempts to optimize the extent size based on past operations on the smart large object and other storage characteristics (such as maximum bytes) that it obtains from the inheritance hierarchy of storage characteristics.

Do not change this system value unless you know the allocation extent size for the smart large object. Only applications that encounter severe storage fragmentation should ever set the allocation extent size. For such applications, make sure that you know exactly the number of bytes by which to extend the smart large object.

Return codes

0: The function was successful.
-1: The function was not successful.