Converting basic row format table spaces with validation 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 validation 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 a validation routine:

  1. Use the ALTER TABLE statement to alter the validation routine to NULL.
  2. Run the REORG utility or the LOAD REPLACE utility to convert the table space to reordered row format.
  3. Make any necessary modifications to the validation routine so that it can be used with rows in reordered row format.
  4. Use the ALTER TABLE statement to add the modified validation routine to the converted table.
    End program-specific programming interface information.