Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Considerations for PCTFREE FOR UPDATE

(BMC.DB2.SPE2307)

REORG PLUS honors SYSTABLEPART.PCTFREE_UPD and Db2 system parameter PCTFREE_UPD with exceptions noted below.

Related topics

Operational considerations

PCTFREE FOR UPDATE is ignored when one of the following conditions exists:

  • PCTFREE FOR UPDATE is set to -1.
  • System parameter PCTFREE_UPD is set to AUTO and the PCTFREE FOR UPDATE clause was not used at create time.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

REORG PLUS for DB2 13.1