Using system-specified storage characteristics
HCL OneDB™ uses one set of storage characteristics as the system-specified storage characteristics.
About this task
- If the sbspace in which the smart large object is stored specifies
a value for a particular storage characteristic, the database server
uses the sbspace value as the system-specified storage characteristic.
The database administrator can use the onspaces utility to define storage characteristics for an sbspace.
- If the sbspace in which the smart large object is stored does
not specify a value for a particular storage characteristic, the database
server uses the system default as the system-specified storage characteristic.
The database server defines the system defaults for storage characteristics internally. However, you can specify a default sbspace name with the SBSPACENAME configuration parameter in the onconfig file. Also, an application call to ifx_lo_col_info() or ifx_lo_specset_sbspace() can supply the target sbspace in the smart-large-object specification structure.
It is recommended that you use the system-specified storage characteristics for the disk-storage information. For more information about sbspaces and the description of the onspaces utility, see your HCL OneDB Administrator's Guide.
To use system-specified storage characteristics for a new smart large object:
Procedure
- Call ifx_lo_def_create_spec() to allocate a smart-large-object specification structure and to initialize the structure to null values.
- Call ifx_lo_create() to create an instance of the smart large object.