DB2 AS/400 (iSeries) to SAP HANA Online Presentation


Demo presentation text:

Hello!

Let me show you a Demo Presentation of the migration tools provided by Ispirer Systems for the DB2 iSeries to SAP HANA migration.

First of all, I’d like to mention that Ispirer Systems provides tools and services for automating database and application migration processes for a variety of conversion directions. The list of tools supplied for such a kind is as follows

• SQLWays Wizard – a GUI tool that is designed to simplify the database conversion process tuning for the sqlways command-line tool. Works with the source database using the ODBC connection.

• SQLWays Studio – a GUI tool that is designed to simplify the database or application script conversion process tuning for the sqlways command-line tool. Works with one script at a time

• SQLWays Commander – a GUI tool that is designed to simplify the database or application scripts conversion process tuning for the sqlways command-line tool. Works with several scripts at a time.

• Sqlways.exe – a command line tool that can be in batch mode and can perform the automatic conversion of the database using the ODBC connection or the database and application code provided in scripts.

During this Demo I will show you the DB2 iSeries to SAP HANA migration using SQLWays Wizard, SQLWays Studio and SQLWays command tools mentioned in the list provided.

First, let’s start with SQLWays Wizard.

This is a tool that can connect to DB2 iSeries database using an ODBC connection. So to migrate from DB2 iSeries to SAP HANA you need to provide an ODBC DSN for DB2 iSeries on a “Сhoose a source database” page. In addition, you need to specify a user and a password with the appropriate rights for making selection from system tables from DB2 iSeries.

On a “Сhoose a target database” page you need to choose a target database from the list of the supported databases. As you can see SAP HANA database is specified here. You also need to provide other credentials for the SAP HANA database for support of definitions and data load using native utilities of this database

All the objects that SQLWays manages to extract from the DB2 iSeries are represented in a tree view on the “Specify Database Objects or Query” page. Here you can select all the objects required for the migration.

After that, you can specify different options for automated DB2 iSeries to SAP HANA conversion, options that can control schema name conversion, reserved words conversion, data types conversion, identifier names conversion, object name and etc. Also there are options that can help you to run the definitions and data migration as separate processes.

On the “Specify Export File Options” page you need to provide directory which serves as an intermediate repository for the whole migration process and stores all the automatically generated files like sql files with the converted definitions of the objects, text files with the data prepared to be loaded into the target database, bat or SH files with the commands for the native utilities to load the data.

The whole process of migration from DB2 iSeries to SAP HANA is performed in two steps: export stage during which information is extracted from the source database and is converted, and import stage –which represents the download of information prepared to the target system. Each stage has its own reports with information on the progress of the migration.

With the export process there are sqlwayslog files provided that contain the information about the objects migrated from the source database, their number, the number of rows of data and the size of the data per each table extracted, the number of lines of code per each business logic object etc. At the end of the export log file there is a summary information per each object group and the information on the export status and issues if there are any.

Similar information but in more readable format is provided in the sqlways_report.html file.

Data from the source database is transformed into csv files loaded into SAP HANA using control file. This is a csv file, and that is a ctl file in which the loading rules are described.

Now let’s run SQLWays Studio that can be used for sql scripts migration from DB2 iSeries to SAP HANA. All you need to do to migrate scripts from DB2 iSeries to SAP HANA is to paste the script that you need to migrate in the left window, choose the source and target directions and run the migration. In the right window you can see the results of the migration.

And now let’s use SQLWays Commander that hepls to perform migration of files with sql scripts from DB2 iSeries to SAP HANA. In order to migrate files with sql scripts we should choose the direction and run the migration. Once the migration has been completed, in the right window you can see a file with the same name. That is the converted file.

Then, SQLWays Commander allows to migrate several files at a time or the whole folder. To migrate the whole folder you need to select the folder, choose the migration direction and run the migration. In the right panel, we can see this folder with converted scripts with the same name.

That’s all I wanted to tell you in this Demo. The information about the peculiarities of DB2 iSeries to SAP HANA migration and other tool that Ispirer Systems provides for database migration support will be described in our next Demos or can be found on our website. I hope this Demo was useful. Thank you!

Do you want to move from DB2 AS/400 to SAP HANA?

Let's do it together!

Learn more