Mainframe Data Migration
Overview
Verang has extensive experience in migrating mainframe databases and data sets to modern environments. We have experience solely rehosting mainframe database as well as rehosting databases during full modernization of legacy systems. In our experience, only Oracle, DB2, and MSSQL provide sophisticated enough configurations for scaling and redundancy, and along with the Cloud are our target environment when rehosting a database.
Source Mainframe Databases/Data Sets and Emulators
| Source Mainframe Databases and Data Sets |
|---|
| ADABAS |
| Any RDMS vendor to another RDMS vendor |
| DB2 |
| IDCAMS (for VSAM data-sets) |
| IDMS |
| IMS/DB |
| QSAM (including GDG emulation) |
| TERADATA (SQL migration and data migration) |
| VSAM |
| OS & TP Monitor Emulations |
|---|
| Batch (JES and some TSO functions) |
| CICS |
| IMS/DC |
| Web Services (autogen from subroutines) |
Target Mainframe Databases/Data Sets and Platforms
| Target Mainframe Databases/Data Sets |
|---|
| DB2 UDB version 9 or better |
| MSSQL 2014 or newer |
| MySQL (VSAM/QSAM/DB2 only) |
| Oracle 11g or better |
| PostgreSQL (VSAM/QSAM/DB2 only) |
| Target Platforms |
|---|
| Any platform that supports Java version 1.8 or better |
| Linux 32 and 64 bit - Red Hat, Ubuntu, Fedora, Centos, etc. |
| Unix |
| USS (OMVS) |
| Windows 32 and 64 bit |
| And other platforms |
DATA MIGRATION FRAMEWORK
Verang’s proprietary set of internally developed applications and processes is called the “Data Migration Framework” (DMF). Verang’s DMF embodies procedures, technical know-how and applications developed throughout the years of working on mainframe data migration projects.
The DMF platform allows for automation of many labor intensive steps in mainframe migration projects including:
- assessing and analyzing data sources to be migrated
- generating relational data model and DDL scripts for building relational databases
- converting unloaded files from source to target encoding
- generating programs for unloading data from the source environment
- creating loading scripts for populating relational target databases
- generating and deploying tools to support migrated data in relational target database
- validating the migrated data
DMF is configurable to meet the requirements of all common types of migration projects and environments. Being configurable, DMF allows for:
- easy customization for various source and target environments
- choice of preferred normal form for relational databases
- modifications dictated by performance issues in the migrated environment
- selection of several data loading strategies
- implementation of various data validation strategies
- risk reduction in handling and resolving of unforeseen situations encountered during the migration
Verang’s automated migration methodology allows for repeated and fast conversion cycles that minimally involve human interaction and produce reliable and uniform results.
Migrating to the Cloud
Verang is flexible in migrating databases to target mainframes or to a Cloud storage. When migrating to the Cloud, Verang uses industry partners who specialize in FedRamp certified Cloud service providers such as Amazon Webs Services or Microsoft Azure to successfully migrate the legacy mainframe to a secure Cloud service provider.