Skip to Content
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 REORG PLUS for DB2 13.1.

Reordered row format

REORG PLUS supports reordered row format (RRF), as follows:

  • REORG PLUS reorganizes data that is in RRF.
  • REORG PLUS converts data from basic row format (BRF) to RRF.

Row format considerations

The following considerations apply to RRF support in REORG PLUS:

  • When converting objects from BRF to RRF, REORG PLUS ignores FSFALLBACK YES.
  • REORG PLUS does not support mixed-format partitions in a single reorganization if you have disabled RRF. In this case, you must run separate partial reorganizations: one to reorganize the BRF partitions, and another to reorganize the RRF partitions.
  • If a table space is compressed and a REORG PLUS job would convert the row format, REORG PLUS builds a new dictionary except when both of the following options are in effect:
    • The value of the REORG PLUS KEEPDICTIONARY option is YES.
    • The value of the Db2 subsystem parameter HONOR_KEEPDICTIONARY is YES.

  • (SPE2005) On an Db2 version 12 FL500 and higher, REORG PLUS converts the object to Reordered Row Format (RRF) except for the conditions listed below:

    • Creation of objects in Basic Row Format (BRF) was deprecated with FL500.
  • REORG PLUS does not convert objects from BRF to RRF when any of the following conditions exists:
    • Any table in the table space has an EDITPROC or VALIDPROC.
    • You are reorganizing a catalog object.
    • You are reorganizing a clone object or a base table space for which a clone relationship exists.

Related topic

Operational-considerations

 

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

REORG PLUS for DB2 11.2