THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Migrate IBM DB2 iSeries to SAP HANA

Sap Hana

The database migration tool Ispirer MnMTK can convert DB2 iSeries to SAP HANA. You can use our conversion tools for stored procedures, functions, triggers, database schema (DDL), and other database objects migration. We help understand our clients the value of automated database and application migration solutions that enable business growth.


DB2 iSeries to SAP HANA Migration Overview

The tool migrates the following database objects and properties to SAP HANA:
  • Stored Procedures, Functions and Triggers conversion
  • Schema (DDL) conversion
  • Indexes, Views, Sequences conversion
  • Transfers Data
This demo shows how Ispirer MnMTK can migrate DB2 iSeries to SAP HANA database:

DDL conversion:

  • Converts columns definitions - data types, default values, NOT NULL constraints
  • Converts primary and foreign keys
DB2 iSeries:
  1. CREATE TABLE EMPLOYEE
  2. (EMP_NO INT NOT NULL,
  3. SALARY DOUBLE NOT NULL,
  4. FIRST_NAME VARCHAR(12) NOT NULL,
  5. DATESTART DATE DEFAULT CURRENT DATE,
  6. PRIMARY KEY (EMP_NO)
  7. )
  8. ;
  9.  
SAP HANA:
  1. CREATE TABLE EMPLOYEE
  2. (
  3. EMP_NO INTEGER NOT NULL,
  4. SALARY DOUBLE NOT NULL,
  5. FIRST_NAME VARCHAR(12) NOT NULL,
  6. DATESTART DATE DEFAULT CURRENT_DATE,
  7. PRIMARY KEY(EMP_NO)
  8. );
  9.  

Stored Procedures conversion:

  • Converts procedures syntax, cursors, statements
  • Converts variables and parameters
  • Converts comments
DB2 iSeries:
  1. CREATE PROCEDURE MEDIAN_RESULT_SET (MedianSalary DOUBLE)
  2. RESULT SETS 1
  3. LANGUAGE SQL
  4. BEGIN
  5. DECLARE c2 CURSOR WITH RETURN FOR
  6. SELECT EMP_NO, SALARY
  7. FROM EMPLOYEE
  8. WHERE SALARY > MedianSalary
  9. ORDER BY SALARY;
  10. OPEN c2;
  11. END;
  12.  
SAP HANA:
  1. CREATE TYPE SWT_MEDIAN_RESULT_SET
  2. AS TABLE(EMP_NO INTEGER, SALARY DOUBLE);
  3.  
  4. CREATE PROCEDURE MEDIAN_RESULT_SET(medianSalary DOUBLE,
  5. OUT SWV_Result SWT_MEDIAN_RESULT_SET)
  6. LANGUAGE SQLSCRIPT
  7. AS
  8. BEGIN
  9. SWV_Result = SELECT EMP_NO, SALARY
  10. FROM EMPLOYEE
  11. WHERE SALARY > :MedianSalary
  12. ORDER BY SALARY;
  13. END;
  14.  

Stored Functions conversion:

  • Converts syntax and statements
  • Converts parameters and variables
  • Converts comments
DB2 iSeries:
  1. CREATE FUNCTION HANA.REVERS(INSTR VARCHAR(4000), POS INT)
  2. RETURNS VARCHAR(1000)
  3. DETERMINISTIC NO EXTERNAL ACTION CONTAINS SQL
  4. BEGIN ATOMIC
  5. DECLARE REVSTR VARCHAR(4000);
  6. DECLARE LEN INT DEFAULT 0;
  7. SET LEN = LENGTH(INSTR);
  8. SET REVSTR = SUBSTR(INSTR, POS, LEN - POS +1);
  9. RETURN REVSTR;
  10. END ;
  11.  
SAP HANA:
  1. CREATE PROCEDURE HANA.REVERS(OUT RETURNVAL VARCHAR(1000),
  2. INSTR VARCHAR(4000), POS INTEGER)
  3. LANGUAGE SQLSCRIPT
  4. AS
  5. REVSTR VARCHAR(4000);
  6. LEN INTEGER DEFAULT 0;
  7. BEGIN
  8. LEN := LENGTH(:INSTR);
  9. REVSTR := SUBSTRING(:INSTR,:POS,:LEN -:POS+1);
  10. RETURNVAL := :REVSTR;
  11. END;
  12.  

Triggers conversion:

DB2 iSeries:
  1. CREATE TRIGGER RAISE_LIMIT
  2. AFTER UPDATE OF SALARY ON EMPLOYEE
  3. REFERENCING NEW AS N OLD AS O
  4. FOR EACH ROW
  5. WHEN (N.SALARY > 1.1 * O.SALARY)
  6. BEGIN
  7. DECLARE MAX_SALARY FLOAT;
  8. SELECT MAX(SALARY) INTO MAX_SALARY FROM EMPLOYEE
  9. WHERE EMP_NO = O.EMP_NO;
  10. IF N.SALARY > MAX_SALARY
  11. THEN UPDATE SAMPLE SET SALARY = N.SALARY
  12. WHERE EMP_NO = O.EMP_NO;
  13. END IF;
  14. END;
  15.  
SAP HANA:
  1. CREATE TRIGGER RAISE_LIMIT
  2. AFTER UPDATE
  3. ON EMPLOYEE
  4. REFERENCING NEW ROW N,OLD ROW O
  5. FOR EACH ROW
  6. BEGIN
  7. DECLARE MAX_SALARY FLOAT;
  8. IF :N.SALARY > 1.1*:O.SALARY THEN
  9. SELECT MAX(SALARY) INTO MAX_SALARY FROM EMPLOYEE
  10. WHERE EMP_NO = :O.EMP_NO;
  11. IF :N.SALARY > :MAX_SALARY
  12. THEN
  13. UPDATE SAMPLE SET SALARY = :N.SALARY
  14. WHERE EMP_NO = :O.EMP_NO;
  15. END IF;
  16. END IF;
  17. END;
  18.  

Views conversion:

DB2 iSeries:

  1. CREATE VIEW VW_BONUS(customer, bonus) AS
  2. SELECT name, total/items_count * rate FROM
  3. CUSTOMERS INNER JOIN ORDERS
  4. ON CUSTOMERS.id = ORDERS.order_id
  5. WHERE date_of_birth >= CURRENT_DATE - 18 YEARS ;
  6.  
SAP HANA:
  1. CREATE VIEW VW_BONUS(customer, bonus) AS
  2. SELECT name, total/items_count*rate FROM
  3. CUSTOMERS JOIN ORDERS
  4. ON CUSTOMERS.id = ORDERS.order_id
  5. WHERE date_of_birth >= ADD_YEARS(CURRENT_DATE,-18);
  6.  

Ispirer MnMTK Features for DB2 iSeries to SAP HANA Migration

  • Quick and Useful Conversion of SQL Scripts - You can easily start converting existing SQL scripts - DDL statements, SQL queries etc.
  • Conversion with Database Connection - Ispirer MnMTK can connect to DB2 iSeries, extract and convert the entire database or just specified objects and schemas
  • Generates SQL scripts in SAP HANA syntax
  • Command Line Support can help you automate the migration process
  • Migration Validation - The tool can compare the number of tables, the number of rows, and perform data validation for all or selected columns (based on primary keys or specified order clause)

Why Ispirer MnMTK for DB2 iSeries to SAP HANA

Ispirer MnMTK and our support ensure low cost and nearly 100% automation of the entire DB2 iSeries to SAP HANA migration.

  • ~100% Automation of All 3 Stages - Consistent and Integrated
    • Stage 1: Database schema/DDL, server-side business logic (stored procedures, triggers etc)
    • Stage 2: Data transfer and validation
    • Stage 3: Front-end application code and SQL queries/scripts
  • Fast Customization - Free fixes within 1-2 business days
  • Pre-Sale Engagement - We demonstrate full conversion during the evaluation before you make a decision. Engagement Process
  • Low Cost - We offer flexible pricing
  • Optimized Conversion - Intelligent and maintainable code, no any Ispirer's middleware used after conversion

When you need to migrate from DB2 iSeries to SAP HANA we are right here to help you!

Try the Toolkit

Ispirer MnMTK 2017

DB2 iSeries to SAP HANA

Data and SQL SQL Data

Estimate Your Project

Ispirer MnMATK 2017

DB2 iSeries to SAP HANA

Download

Purchase the Toolkit

Ispirer MnMTK 2017

DB2 iSeries to SAP HANA

Data and SQL SQL Data

Purchase Service

Ispirer Migration Service

DB2 iSeries to SAP HANA

Data and SQL SQL Data

Contact us for more information.

 
SAP HANA Database

SAP HANA SP08 and earlier

IBM DB2 iSeries Databases

IBM DB2 for iSeries and AS/400 7.1.x, 6.1.x, V5R4, V5R3, V5R2, V5R1, V4R5, V4R4

Testimonials
September 1, 2014Continental Tire the Americas, LLC, United States
DB2 to Oracle Migration

"Recently it became necessary to migrate our existing DB2 database into an Oracle environment. Our migration required that all tables, data, triggers and functions...

...

October 9, 2013Ventyx, Australia
DB2 LUW to Oracle on Linux Migration

"To whom it may concern,
My name is Bill Lloyd and I work as a Senior DBA for Ventyx, a leading software company supplying software products primarily to the...

...

Feedback

Now the developers know your tool works fine…
Thanks for your assistance and we take into account Ispirer for this migration or any other we have to do in the future.

Read more
Industry Events