Row format conversion for table spaces

Start of change The row format of a table space might be converted when you run the LOAD REPLACE or REORG TABLESPACE utilities. End of change

If the DB2® subsystem parameter RRF is set to ENABLE, the table space is converted from basic row format to reordered row format when you run the LOAD REPLACE utility or the REORG TABLESPACE utility. (The default setting for the RRF subsystem parameter is ENABLE.) If the RRF subsystem parameter is set to DISABLE, the table space is not converted. Therefore, if the table space was in basic row format before running the LOAD REPLACE utility or the REORG TABLESPACE utility, the table space remains in basic row format. Likewise, if the table space was in reordered row format before running either of these utilities, the table space remains in reordered row format.

Exceptions:

LOB table spaces and table spaces in the catalog and directory databases always remain in basic row format, regardless of the RRF subsystem parameter setting, or the setting of the ROWFORMAT keyword for the utility. (The ROWFORMAT keyword specifies the output row format in a table space or partition. This keyword overrides the existing RRF setting when specified.)
XML table spaces always remain in reordered row format, regardless of the RRF subsystem parameter setting or the utility keyword setting.
For universal table spaces that are cloned, both the base table space and the clone table space remain in the same format as when they were created, regardless of the RRF subsystem parameter setting or the utility keyword setting.
When multiple data partitions are affected by the LOAD REPLACE utility or the REORG TABLESPACE utility, and some of the partitions are in basic row format and some are in reordered row format, the utilities convert every partition to reordered row format. This behavior is the default, regardless of the RRF subsystem parameter setting. Alternatively, you can specify ROWFORMAT BRF in the utility statement for all affected partitions so that the table space is in basic row format after the utility completes successfully.

Example

To convert an existing table space from reordered row format to basic row format, run REORG TABLESPACE ROWFORMAT BRF against the table space. To keep the table space in basic row format on subsequent executions of the LOAD REPLACE utility or the REORG TABLESPACE utility, continue to specify ROWFORMAT BRF in the utility statement. Alternatively, you can set the RRF subsystem parameter to DISABLE.