Row format conversion for table spaces

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

Start of changeThe table space is converted from basic row format to reordered row format when you run one of the following utilities:End of change

  • Start of changeLOAD REPLACE with the ROWFORMAT RRF option, or LOAD REPLACE without the ROWFORMAT option. The ROWFORMAT option is deprecated and will be removed eventually.End of change
  • Start of changeREORG TABLESPACE with the ROWFORMAT RRF option, or REORG TABLESPACE without the ROWFORMAT option. The ROWFORMAT option is deprecated and will be removed eventually.End of change
Exceptions:
  • Start of changeLOB table spaces and table spaces in the catalog and directory databases always remain in basic row format, regardless of the setting of the ROWFORMAT keyword for the utility. (The ROWFORMAT keyword specifies the output row format in a table space or partition.)End of change
  • 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. 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.