Skip to Content

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Related topic

Operational considerations

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.
  • On a Db2 version 12 FL500 and higher, REORG PLUS converts the object to Reordered Row Format (RRF) except for the conditions listed below:
    • The 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 exist:
    • 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.

 

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

REORG PLUS for DB2 13.1