High Level Over View

To accelerate the standard process of BDLS System Copy GT breaks the process down into two sections interval generation and the update component.

When running ‘Interval Generation’ in parallel (recommended) it is completed by the program /BTR/MDR_PP_FBDLS_IVLGEN it breaks down all of the tables in the system that require the logical names to be updated. These tables are broken down into intervals as per the commit size, so if we use a commit size of 100,000 a table of 1,000,000 rows will have 10 intervals each of 100,000 records and we use the first and last key fields to ID the start and end of the interval. A table under 100,000 records will simply have one interval. Note that different tables will require different interval sizes for the best performance.

The ‘Update’ is completed by the program /BTR/MDR_PP_FBDLS_MULTI this takes all of the intervals generated by the process above and uses a specified number of processors to update the parts of the tables. The number of processors utilised can be adjusted at runtime.