IMS Data Conversion

The IMS data extract and relational load process is simple and straightforward. During the extract process, all IMS 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. ATERAS 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

Special workbenches within DB-Shuttle® provide additional capabilities for tailoring your IMS migration so that it better meets your needs and requirements:

• Rename 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