RCU: PCTFREE for UPDATE support

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

 What support is provided for the PCTFREE for Update on tablespaces in RC/Update?

Environment

Release : 20.0

Component : RC/Update for DB2 for z/OS

Resolution

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 
SYSTABLEPART.

Perform an ICL to DDL analysis to generate a CREATE TABLE DDL statement that preserves 
these values.

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.

Additional Information

From the DB2 12 SQL Reference: