MBI

The MBI keyword is valid with the OREORG and ANALYZE commands.

You can specify this option in PLUSIN. The following table describes the keyword.

To do this

Specify this in PLUSIN

Specify the minimum number of expected blocks saved after reorganization to qualify the record for reorganization.

MBI(n)

Internal default: 5

The MBI (minimum block improvement) keyword specifies the minimum number of expected blocks to be saved per database record. For example, if MBI(5) is specified, the number of blocks that a record spans must be reduced by 5 after the reorganization. If the MBI criterion cannot be met, the record is not recommended for reorganization.

Valid values are 1 through 9999.

Note

BIPF() and MBI() criteria must be met to qualify a record for reorganization. For more information, see BIPF.

Related topic

Keyword-descriptions-user-controlled-options

 

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