H2R
H2R (Hierarchical to Relational) is an application that faclilitates the migration of data from hierarchical data structures such as IMS/DB to RDBMS such as SQL, DB2 and Oracle without any changes to applications or business logic.
The H2R suite is divided into two main components; the Migration application and the H2R Gateway.
The Migration application consists of various tools, which are necessary for the migration the IMS7DB data to DB2.

Migration Tool
The tools enable the analysis of the IMD/DB data across automated and file configured functions, thus generating the objects required for the creation of the new database, DB2.
One hierarchical segment, corresponds to a new RDBMS dataset, and the traced records, defines each new column of the same segment.
H2R Gateway
The Gateway consists of approximately 10 modules written in COBOL and recompiled for the target Mainframe, including some assembler modules.
The gateway is used for communication between the user applications and the system in question. It is capable of mapping the data and the access to the relational database to retrieve information for the user programs in the same way as in the IMS/DB original.
In order to leave unchanged the user interface, two different modules, with specific aims, are provided:
-
Standard entry points: this modules, having the same name as the IBM DB/DC standard entry point (CBLTDLI, PLITDLI), handle the parameters list prepared by the user program, and normalize it for the H2R kernel calls.
Although the data structure and architecture are completely different between IMS/DB (DL/1) and Oracle „ or DB2 „ , performances of migrated applications are normally equal or better than before.
H2R is currently available on the following platforms:
If you want to know something more about H2R, download the H2R brochure
, or contact us with any further questions.