LOB INLINE LENGTH field (LOB_INLINE_LENGTH subsystem parameter)
The LOB_INLINE_LENGTH subsystem parameter specifies the default length (in bytes) that is to be used for inline LOB columns.
An inline LOB is the portion of a LOB column that resides in the containing table's base table space rather than in the column's auxiliary table space. The value in this field is used when the INLINE LENGTH option is not specified in the definition of a LOB column in a CREATE TABLE or ALTER TABLE ADD statement.
| Acceptable values: | 0–32680 |
|---|---|
| Default: | 0 |
| Update: | option 13 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP LOB_INLINE_LENGTH |
When you enter a value in this field, keep the following
points in mind:
- A value of 0 causes LOB columns to be created with no inline attribute by default.
- Odd values are rounded to the next even integer for any DBCLOB column created. For example, if you enter 1023, then 1024 bytes of data for new DBCLOB columns reside in the base table.
- The value of this parameter is in bytes, regardless of the LOB column's data type or subtype.
If the value of this parameter causes the page size to be exceeded for a table in a universal table space, Db2 uses a LOB inline length value of 0 instead of this parameter value when it recalculates the record size.