PRODUCTS H2R

H2R

 

H2R logoH2R (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.

H2R Gateaway

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.

  • High Level Program Interface (HLPI): this module automatically transforms all EXEC DLI statements into the corresponding Call-Level request, as expected by the standard entry point module.

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:

Unix
Linux Windows z/os

 

If you want to know something more about H2R, download the H2R brochure , or contact us with any further questions.