We provide toleration support, if the UPDATE value exists in the catalog and we do a DROP/CREATE we will not lose the attribute value, but you can not use the tools to modify it's value.
(SYSTABLESPACE AND SYSTABLEPART contain a column PCTFREE_UPD)
The value in the catalog is the value we preserve for the UPDATE attribute. If the value is NULL, most likely we leave the column off and then the ZPARM value is used (PCTFREE_UPD).
This was added in R19:
In the R19 techdocs, under New Features for RCU/RCM and RCC is the following detail:
PCTFREE FOR UPDATE Support
The CREATE TABLESPACE syntax for the PCTFREE n clause with the FOR UPDATE n attribute is now
supported in RC/Compare, RC/Migrator, and RC/Update. This clause and attribute can be
specified at the tablespace or partition level for Db2 11 or higher subsystems.
Use the PCTFREE clause with the FOR UPDATE attribute to improve the use of free space.
From RC/Migrator and RC/Compare, you can:
Use the Syntax Checker to validate CREATE TABLESPACE syntax that contains the
PCTFREE n FOR UPDATE clause. Validation occurs at the tablespace level or the partition level.
Use Strategy Services migration, alteration, and comparison strategies to migrate, alter, and
compare tablespaces and preserve the value of the clause in SYSTABLEPART.
Import DDL as the source or the target of a Compare strategy to compare a CREATE TABLESPACE
statement that includes the PCTFREE n clause with the FOR UPDATE n attribute at the tablespace or partition level.
Generate ICL for a CREATE TABLESPACE statement that includes the PCTFREE_UPD value from
Perform an ICL to DDL analysis to generate a CREATE TABLE DDL statement that preserves
In RC/Update, you can use Db2 object management panels to alter tablespace attributes.
When the alteration requires a drop and recreate, the FOR UPDATE value is preserved. You
can also use the panels to template a tablespace and have the FOR UPDATE attribute templated.
You cannot alter the FOR UPDATE value from the product panels.