extended_row_sz - Extended row size configuration parameter
You can use the extended_row_sz configuration parameter to control if a table definition can exceed the maximum row length of a page.
- Configuration type
- Database
- Parameter type
- Configurable online
- Default [range]
- ENABLE [DISABLE, ENABLE]
If you are upgrading from Version 10.1 or earlier, the default value of extended_row_sz is DISABLE.
When extended_row_sz is set to DISABLE, extended row size is disabled. Existing tables with extended row size as indicated by the EXTENDED_ROW_SIZE column of the SYSCAT.TABLES are unaffected.
When
extended_row_sz is set to ENABLE, extended row size is
enabled. During an INSERT or UPDATE table operation, row data that exceeds the maximum row length
moves a subset of VARCHAR, VARBINARY, or VARGRAPHIC data out of the row and stores it as LOB data.
While the data is in LOB format, data access might be slower because additional I/O resources might
be required to fetch, insert, or update the LOB
data.
Note: After an extended row
size table is altered, the first offline REORG enforces LONGLOBDATA. This can increase the time
required to REORG the table.