PCTFREE for UPDATE support within RC/Update
search cancel

PCTFREE for UPDATE support within RC/Update

book

Article ID: 233950

calendar_today

Updated On:

Products

RC/Update for DB2 for z/OS

Issue/Introduction

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

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 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:

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=0Qor8I18FCpuUfeTDzJtDg==