Method 2: Database reconfiguration with export

With this method, the table is converted in these steps:

  1. The table data is exported to a temporary file. The name of this file is R.<table name><company number> , for example, R.tfgld106590.
  2. Indexes that must be changed or dropped are dropped.
  3. The table is converted by issuing multiple SQL ALTER TABLE commands to the database.
  4. Indexes that must be changed or created are created.

After successful completion, the temporary file will be deleted. The temporary file is used by bdbreconfig to restore the original table when reconfiguration fails.