Free space management enhancements
In Db2 11, you can reserve free space in table spaces for use only by UPDATE operations.
By reserving the space for UPDATE operations, you can improve performance. The free space enables your data to remain clustered longer and reduces the use of overflow records and indirect references, which degrade performance.
You can specify the PCTFREE FOR UPDATE option when you create or
alter a table space. When you specify that option, Db2 reserves space for future UPDATE operations.
The reserved space is not used by INSERT operations or utilities that
add data to the table space. The FOR UPDATE value specifies the percentage
of each page that is reserved to be used only by future UPDATE operations.
You can specify FOR UPDATE -1 to specify that Db2 uses real-time statistics to
automatically calculate how much free space to reserve for updates.
The PCTFREE_UPD subsystem parameter specifies the default value of the PCTFREE FOR UPDATE option.