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.

+FREEPAGE

The +FREEPAGE parameter specifies the number of pages between empty pages in the table space. You can use this parameter when reorganizing a table space (RRGPARMS) or a table index (RRGPARMX). 

GUID-D65179C0-CE2E-4FDC-B82E-2A2E3C23B6EC-low.png

Related topics

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

Fine-tuning-BMC-AMI-Reorg

The default value is specified at installation time. The value specified must be between 0 and 255. If nothing is specified by the user at installation time, the configuration uses the default value of -1.

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 will revert to the original value.

-1

Continues to use the FREEPAGE value currently in use

integer

An integer representing the new FREEPAGE value

Important

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

Example
+FREEPAGE(35)

BMC AMI Reorg inserts an empty page after every 35 pages of the table space.


 

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