PCTFREE for UPDATE support within RC/Update
search cancel

PCTFREE for UPDATE support within RC/Update


Article ID: 233950


Updated On:


RC/Update for DB2 for z/OS


 What support is provided for the PCTFREE for Update on tablespaces in RC/Update for Db2 for z/OS (RCU).


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 cannot 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).

Additional Information

From the DB2 12 SQL Reference: