VSAM Conversion and Migration
The ATERAS® VSAM conversion includes the generation of a new relational database to replace the functionality, redefinitions, type-of-record indicators, and other data element structures that are currently part of most VSAM files. The new target database can reside on the mainframe or off the mainframe, and can use any of the standard relational database management systems (RDBMS): Microsoft SQL Server, Oracle or IBM DB2.
ATERAS also handles the conversion of the applications that use the VSAM files. ATERAS can convert COBOL, PL/1, Assembler, JCL and Procs for VSAM applications.
Replacement of VSAM Database Functionality
The ATERAS solution provides a complete replacement for all VSAM file functionality including multi-view records, occurring fields, indexes and more. The resulting database is fully relational. Primary keys and index definitions are automatically created. All constraints are generated into the resulting DDL. Table spaces, indexes, table names and column names are all generated according to your naming standards. More about the replacement database functionality.
Relational Database Options
- Microsoft SQL Server on Windows
- IBM DB2 (or UDB) on the mainframe
- IBM UDB on Windows
- IBM UDB on Unix
- Oracle on the mainframe
- Oracle on Windows
- Oracle on Unix
VSAM Data Conversion
The VSAM data extract and relational load process is simple, straightforward and fast. ATERAS can provide a number of extract variations for sites that have special requirements for a short IMS data conversion window. Special workbenches within DB-Shuttle® provide additional capabilities for tailoring your VSAM migration so that the new database meets your needs and requirements. More about the VSAM data conversion.
Visibility and Knowledge Building
ATERAS also ensures that the customer teams have a full understanding of the existing VSAM file structures, as well as a full understanding of the post-conversion relational databases. DB-Shuttle generates many reports and diagrams to assist with this knowledge-building process. More about the enhanced visibility and knowledge building.
Contact ATERAS for additional information and a price quote for your VSAM conversion.