Recloning a Database

Recloning the relational database can be an efficient means of recovering it if it doesn't contain a lot of data. Otherwise, it can be time-consuming and costly, as recloning uses host resources. These reasons alone often make recloning a last resort when no backup is available.

We recommend that you use the following procedure instead of setting ds_mode to 0 for all data sets using a SQL query and running a process command, because it ensures that you have the latest copy of the DMSII layout.

To reclone the database

  1. Make sure that you have the latest copy of the DMSII layout.
  2. Run a drop command to drop the data source.
  3. Run a define command.
  4. Run a generate command.
  5. Run a process command.