IDMS Modernization Options

Automated IDMS Conversion

Secure, automated conversion of IDMS database to high-performance, relational DBMS.


Our IDMS conversion strategy includes the generation of a new relational database to replace the functionality, set relationships, indexes, and data structures that are currently part of the IDMS network database. The new target database can reside on or off the mainframe, and can use any of the standard relational database management systems- Microsoft SQL Server, Oracle or IBM DB2.

Modern Systems also handles the conversion of the applications that use the IDMS database including ADS/Online (ADSO), COBOL, Assembler, Easytrieve, JCL and Procs for IDMS applications.



Replacement of Database Functionality through IDMS Conversion

Our IDMS conversion solution provides a complete replacement for all IDMS database functionality including multi-member sets, chained and sorted sets, bill-of-material structures, group and occurring fields, DBKEY usage, and more. Primary keys, foreign keys, and index definitions are automatically created, and all constraints are generated into the resulting DDL. Table spaces, indexes, table names, and column names are all generated according to your naming standards.

Learn More


IDMS Data Conversion

The IDMS data extract and relational load process is simple, straight-forward, and fast. Modern Systems can provide a number of extract variations for sites that have special requirements for a short IDMS data conversion window. Special workbenches within DB-Shuttle provide additional capabilities for tailoring your data migration so that the new database meets your needs and requirements.

Learn More



Visibility and Knowledge Building

Modern Systems also ensures that customer development teams have a full understanding of existing IDMS and post-conversion relational databases. DB-Shuttle generates many reports and diagrams to assist with this knowledge-building process as part of the IDMS conversion solution.

 
Target 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 (existing z/OS Oracle License)
  • Oracle on the mainframe z/Linux
  • Oracle on Windows
  • Oracle on Unix

Sharing IDMS Data Without Migration

Integrate IDMS data with SQL Server, DB2 or Oracle data warehouses.
Get true business intelligence without disrupting the business.
We use our Mainframe DataShare technology to integrate IDMS databases with SQL Server, Oracle, or DB2 data warehouses. High level tasks include:
  • Import the IDMS schema & segments via DDDL, automatically generate Relational schema from System Dictionary
  • Adjust Data Mapping rules and generate relational data model
  • Initial Data Load: transfer existing REPO backups to Windows, convert the IDMS data and run the generated Oracle/SQL/DB2 Load scripts to populate the relational database
  • Ongoing Replication: transfer IDMS Journals to Windows upon release, ‘roll forward’ the IDMS updates against the relational database
  • Validation and verification: ensure referential integrity of the data in the IDMS database is correct, and is maintained during the replication process
  • Prove integrity by implementing constraints to carry-forwards IDMS integrity rules into relational database
  • Ensure row counts agree, validate that Set Membership and Sequence is the same and verify aggregate totals of fields match
2-MINUTE OVERVIEW: Mainframe DataShare

Heads up! This website is no longer being updated as of 2022. For the most up-to-date information on Advanced's modernization services and/or for any enquiries, go to modernsystems.oneadvanced.com.

X