Data Conversion

The IMS data extract and relational load process is simple and straightforward. During the process, all data is extracted and written to a set of sequential files that are ready to load to the new relational database target. The IMS data extracts are fast and can be executed simultaneously. Modern Systems can provide a number of extract variations for sites that have special requirements for a short IMS data conversion window. Data conversion during the cut-over weekend or evening is always fast and complete.

Customization Workbenches to Tailor IMS Data Migrations

Special workbenches within DB-Shuttle™ provide additional capabilities for tailoring an IMS data migration so that it better meets our customers' needs:

  • Re-name Workbenches to allow full naming of all tables, columns, table spaces, and indexes using a rules basis or a full-name basis
  • Data Cleansing Workbench to provide rule-based data cleansing during the IMS data extract process
  • Date Conversion Workbench to allow DATE type columns in the new relational databases (all date formats are supported)
  • Element Rename Workbench which allows selection of group level or elementary IMS fields for use as columns in the relational database
  • Record Re-Definition Workbench to allow changes to field types and lengths during the relational conversion
  • Segment workbench where copybook or hard-code record layouts are associated to the IMS database segments
  • Multi-view workbench processing to allow the specification of multiple data layouts for a single IMS record so that the conversion can include multiple tables to replace the multi-function IMS record
Share This