Handle DMSII Reorganizations

If a DMSII database reorganization changes the layout of records, parallel changes must be applied to the Client database.

You can configure the service to automatically process any DMSII reorganizations that are detected by process commands by using Automatic Run Options.

To handle DMSII reorganizations automatically

  1. In the Explorer view, right-click the data source and choose Client Configuration.
  2. On the left, expand Processing, and select Scheduling.
  3. For Automatic Run Options, select Redefine data source when DMSII reorganization detected.
  4. To automatically create scripts when required, select Generate scripts after an automatic redefine.

    If a DMSII reorganization is detected, the service runs a redefine command, which rebuilds the relational database layout for data sets that have been reorganized. All customizations are preserved. The redefine command compares the old and new table layouts to determine if any changes have occurred.

    • If the table layouts haven't changed, the service starts a process command to resume operations.
    • If the table layouts have changed (for example, data sets added or existing data sets must be re-cloned as a result of the reorganization), scripts must be generated before processing can resume. If you selected Generate scripts after an automatic redefine, the service automatically runs a generate command to create these scripts. If you didn't select this option, create the scripts manually. Select Data Source > Generate Scripts.
    • If the Reorganize command is required, you'll need to run this command before you can resume processing. Use the Client Configurator to make any additional changes to the table layouts. Examine the scripts that the client created to ensure that they're correct and then select Data Source > Reorganize. The Reorganize command generates new scripts for stored procedures. Then, it alters the layout of all tables affected by the reorganization by running the reorg scripts that were created by the redefine command. Finally, it refreshes the stored procedures in the relational database to use the new layouts. When the Reorganize command is finished, you can resume processing.

To handle reorganized items manually

If a DMSII reorganization requires structural changes to your replicated data source, you will be prompted to address the changes in the Client Configurator. The Client Configurator uses the following icons for a data source to indicate changes that have occurred:


This icon

Indicates that



The item was affected by a DMSII reorganization.


Reorg Add

Items were added by a DMSII reorganization.


Reorg Delete

Items were removed by a DMSII reorganization.

  1. In the Explorer view, right-click the reorganized data source and choose Customize Data Source.

    After the Client Configurator starts, it runs a redefine command. Only items that have affected by the reorganization appear in the DMSII view.

  2. In the DMSII view, select an affected data set.
  3. Customize the new data set or new columns using the available options in the DMSII Properties view or the Relational Properties view. See Customize a Data Source.
  4. In the toolbar, click Save Save button.
  5. Choose File > Exit.

    Typically, the Client Configurator automatically runs a Generate command, which allows you to resume processing. The next time you start the Client Configurator, the icons for these items will appear as normal.

  6. If you're prompted to review your scripts, do so.
  7. After you review and approve the scripts, in the Explorer view, right-click the data source and choose Reorganize. This command generates new scripts for stored procedures and refreshes the stored procedures in the relational database. You can begin processing immediately.