Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, 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. 


Related topics

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

Fine-tuning-BMC-AMI-Reorg

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

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.

Important

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

Example
+PCTFREE(-1)

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

 

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