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

In the Explorer pane, right-click the data source and click Client Configuration from the context menu.
On the left, expand Processing, and click Scheduling.
For Automatic Run Options, enable Redefine data source when DMSII reorganization detected checkbox by clicking on it.
To automatically create scripts when required, enable Generate scripts after an automatic redefine checkbox by clicking on it.

If a DMSII reorganization is detected, the Client Manager 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 enable the Generate scripts after an automatic redefine checkbox by clicking on it, the Client Manager service automatically runs a generate command to create these scripts. If you didn't select this option, create the scripts manually by clicking 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 click Data Source > Reorganize. The Reorganize command generates new scripts for creating tables and stored procedures and running the bulk loader. 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.
	Items were added by a DMSII reorganization.
	Items were removed by a DMSII reorganization.

In the Explorer pane, right-click the reorganized data source and choose Customize Data Source from the context menu.

After the Client Configurator starts, it runs a redefine command. Only items that have affected by the reorganization appear in the DMSII pane.
In the DMSII pane, select an affected data set.
Customize the new data sets or new columns using the available options in the DMSII Properties pane or the Relational Properties pane. See Customize a Data Source.
In the toolbar, click Save .
Choose File > Exit from the menu bar.

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.
If you're prompted to review your scripts, do so.
After you review and approve the scripts, in the Explorer pane, right-click the data source and choose Reorganize from the context menu. This command generates new scripts for stored procedures and refreshes the stored procedures in the relational database. You can begin processing immediately.