Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Large object (LOB) components
This topic describes the basic LOB components.
There are three types of LOBs, all of which BMC AMI LOBMaster handles:
- Character large objects (CLOBs)
- Binary large objects (BLOBs)
- Double-byte character large objects (DBCLOBs)
The following table describes the components associated with LOBs:
LOB components
LOB entity | Description |
|---|---|
Base table space | A table space that contains at least one LOB column |
LOB column | A ROW column in the base table space that identifies the LOB Each LOB in a row can be NULL or contain a version number. |
ID | A unique ID that is assigned to each LOB The ID is a 19-byte value that consists of the following parts:
|
LOB index | A unique index on the ID field that indexes the LOB table rather than the base table |
LOB table space (or auxiliary table space) | The Db2 data set that contains the LOB data Each LOB table space contains the LOB data for a specific column in the base table space. If a base table space contains three LOB columns, three separate LOB table spaces exist. |
LOB | A collection of data that has been inserted into a Db2 row in a LOB-defined column A LOB ranges in size from 1 byte to 2 GB. |