Converting basic row format table spaces with edit routines to reordered row format

You can convert basic row format table spaces to reordered row format. If some tables in a table space have edit routines, you cannot convert the table space to reordered row format directly. You must take other actions for the conversion to succeed.

Procedure

Begin program-specific programming interface information.To convert a table space to reordered row format, complete the following steps for each table that has an edit routine:

  1. Use the UNLOAD utility to unload data from the table or tables that have edit routines.
  2. Use the DROP statement to drop the table or tables that have edit routines.
  3. Make any necessary modifications to the edit routines so that they can be used with rows in reordered row format.
  4. Use the REORG utility to reorganize the table space. Using the REORG utility converts the table space to reordered row format.
  5. Re-create tables with your modified edit routines. Also, re-create any additional related objects, such as indexes and check constraints.
  6. Use the LOAD RESUME utility to load the data into the tables that have the modified edit routines.End program-specific programming interface information.