Working with Data-Segment Tables

To minimize disk contention, you can create a file group for the data-segment tables and store the data files for the group on a separate physical disk. After creating the new group, you must, within the Data Map Seg Table file group and Data Seg Table file group configuration settings, change from the primary file group name to the new file group name.

  To change the name of the Data Map Seg Table and Data Seg Table file group:

  1. Launch Workbench and log on to the FDM application.

  2. Select Tools > Configuration Settings.

  3. From Options, select Data Map Seg Table File.

  4. Enter a name, and click Save.

  5. Click Close.

Note:

The data-map and data-seg tables can be separated into two file groups, but, during testing, no significant increase in performance was observed.

After the file group name is specified, the data-map and data-seg tables must be deleted from the primary file group and re-created in the new file group.

Deleting and re-creating the data-map and data-seg tables truncates all data of the tables. After the application is created and before data is loaded, the file group names should be changed and the tables should be re-created.

  To recreate the data-map and data-seg tables:

  1. Launch Workbench, and log on to the FDM application.

  2. Select Tools > Manage Data Segments > Delete, Recreate, and Reassign All Segments.

    The Recreate Segments screen is displayed.

  3. Select the number of segments to create (default is 50 segments) and click Save.

  4. Click Yes to verify that all data should be deleted.

The re-created data-map and data-seg tables are located in the file groups specified under Configuration Settings.