Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
DataBlade® API Programmer's GuideThe Informix® DataBlade® API Programmer's Guide describes information about the DataBlade® API, the C-language application programming interface (API) provided with HCL Informix®.
Data manipulation
Smart large objects
Smart large objects
Information about a smart large objectThe database server keeps storage characteristics and status information about a smart large object: The database server stores this information in a metadata area of the sbspace for the smart large object.
Storage characteristicsThe storage characteristics tell the database server how to manage a smart large object in an sbspace.
Attribute information
Data integrityThe structure of an sbpage in the sbspace determines how much data integrity the database server can provide. An sbpage is the unit of allocation for smart-large-object data, which is stored in the user-data area of an sbspace.

Data integrity

The structure of an sbpage in the sbspace determines how much data integrity the database server can provide. An sbpage is the unit of allocation for smart-large-object data, which is stored in the user-data area of an sbspace.

The database server supports the following levels of data integrity:

High integrity, which tells the database server to use both a page header and a page trailer in each sbpage
The database server uses the page header and trailer to detect incomplete writes and data corruption. This option detects incomplete writes and data corruption.
Moderate integrity, which tells the database server to use a page header, but no page trailer, in each sbpage.
This option cannot compare the page header with the page trailer to detect incomplete writes and data corruption.

Moderate integrity provides the following benefits:

It eliminates an additional data copy operation that is necessary when an sbpage has page headers and page trailers.
It preserves the user data alignments on pages.

Moderate integrity might be useful for smart large objects that contain large amounts of audio or video data that is moved through the database server and that does not require a high data integrity.

By default, the database server uses high integrity (page headers and page trailers) for sbspace pages. You can control the data integrity for a smart large object as part of its storage characteristics.

Important: Consider carefully whether to use moderate integrity for sbpages of a smart large object. Although moderate integrity takes less disk space per page, it also reduces the ability of the database server to recover information if disk errors occur.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.