Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Reorg for Db2 13.1.

+PCTFREE

The +PCTFREE parameter specifies the percentage of free space in each data page of the table space. You can use this parameter when reorganizing a table space or a table index. 

PCTFREE.png

The default value is specified at installation time.

-1

(Default) Continue to use the PCTFREE value currently in use

integer

A value from 0 through 99 representing the new PCTFREE value

Warning

Important

The Db2 catalog is not updated with the new value. This will have no effect on Db2 or the table space unless you run the IBM RECOVER, LOAD, or REORG utilities on the object. In that case, Db2 reverts to the original value.

Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

Information
Example
+PCTFREE(-1)

BMC AMI Reorg uses the PCTFREE value from the DB2 catalog for each object.

Related topics

BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD 

Fine-tuning-BMC-AMI-Reorg


 

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

BMC AMI Reorg for Db2 12.1