IBM I (AS/400) Data Migration for Archive Data

The Infinite I Database Migration Tool for DB2 for IBM I (DB2/400) enables you to completely migrate IBM I, iSeries, and AS/400 data to your Oracle or MS SQL environment. This means archive AS/400’s can be decommissioned and the data will be migrated to industry standard storage in the MS SQL or Oracle database.

No Longer Reliant on AS/400for Archive Systems

The cost of maintaining AS/400 systems for static data environments is exorbitant. Infinite can completely migrate the data to industry standard databases like Oracle or MS SQL in less than 4 weeks at a cost which is dramatically less than maintaining the AS/400 systems and storage.

Easier Reporting with Data in Tables and Views instead of Physicals and Logicals

Once the archive data is migrated to Oracle or MS SQL it will appear as though it was natively produced data within those databases. Reporting is simple, graphical and web-based. The ability to use analytics tools to produce meaningful information from historic data becomes much easier and can be done using standard tools like Tableau.

Levels of Transparency

The Infinite I Database Migration Tool for DB2/400 provides many levels of transparency, including:
• Geographic transparency - Users do not need to know the physical location of data, just the names of the tables to be accessed.
• Network transparency - Users can access the data regardless of the network protocols.
• Operating system transparency - Users do not need to know the operating systems on which the data resides.
• Data storage transparency - Uses can access data regardless of the methodology used for data storage.
• Data access transparency - Applications can access foreign data stores using the same feature-rich language.

These levels of transparency dramatically expand your ability to access and analyze data. For example, in a single request you can integrate sales information from Oracle on AIX and inventory information from Oracle on z/OS with customer information from a migrated AS/400 database without having to know where each piece of information is located or how it is stored. Such transparent data access protects your company's investment in data and applications, while extending your data management power.

Immediate Information Access

Unlike other database migration products that require extensive programming and customizing, the Infinite Database Migration Tool for DB2/400 is a complete, ready-to-use solution, with no programming necessary. From the first day, you can migrate all your AS/400 data to Oracle or MS SQL and use Oracle's or Microsoft’s tools, or any of the many third-party products available for Oracle or MS SQL, to access information in your former AS/400 database because it will actually be an Oracle or MS SQL Database. If your requirements change, Once migrated, Oracle and Microsoft technology makes it easy to relocate your data without changing your application programs.

Sophisticated Service

The Infinite Database Migration Tool for DB2/400, together with the Oracle or MS SQLdatabase, gives you a sophisticated set of services because all your data resides in a single local Oracle or MS SQL database. These services include SQL statement parsing for distribution, database link processing, two-phase commit processing, data dictionary support for Oracle and Microsoft tools, and data type conversions. The Oracle Database Gateway for DB2/400 and Oracle also provide distributed capabilities, including multisite queries, subqueries, joins, and views, all with a single SQL statement.

A Powerful Language

The Infinite Database Migration Tool for DB2/400 is tightly integrated with the Oracle and MS SQL databases. This allows Oracle's powerful SQL and MS SQL to be used against the AS/400 data. You need not learn a new API, SQL language, or AS/400-specific SQL. It allows you to fully leverage your Oracle or MS SQL knowledge today, and exploit Oracle or MS SQL language enhancements in the future.

Superior Connectivity

Connectivity to the AS/400 is provided by Infinite Services with support for TCP/IP. Whether you need to migrate the data from your iSeries to Linux, Windows or a mainframe running z/OS or OS/390, the Infinite Database Migration Tool for DB2/400 delivers true distributed relational database access to the AS/400 data.

Complete Security

Unauthorized access to AS/400 data is protected through a combination of Oracle and MS SQL security mechanisms.

Complete and Easy Data Migration

With the Infinite Database Migration Tool for DB2/400, the tool simply takes a complete SAVF from the AS/400 physical and logical files, recompiles them into their new target platform and writes the data to Oracle in one complete set. This automatically translates EBCDIC data to ASCII and automatically creates tables and views from the original physical and logical files. This is a one-time complete data migration process. Once migrated, you can easily move data from the to workstations or PCs for data manipulation and analysis because it is all in either Oracle or MS SQL.

For decades, Infinite Corporation has provided enterprise-wide data access across disparate hardware platforms. With Infinite's proven migration and integration technology, your AS/400 data can now easily be migrated to an open database environment. The benefits mean that data can be shared in real-time with other Oracle or MS SQL-based applications, BI tools, and data management requirements.

KEY FEATURES

Configuration

• The Infinite Database Migration Tool for DB2/400 resides on the Oracle or MS SQL server.
• Number of users limited only by underlying operating system and the Oracle or MS SQL database.

Access Capabilities

• Read/write access to the former AS/400 database.
• Distributed access through Oracle or MS SQL, including multisite queries, subqueries, joins, and views.
• Distributed transactions protected by Oracle's or Microsoft’s two-phase commit protocol.
• Data transfer between the AS/400 and Oracle or MS SQL, performed in a single statement.

Data Types

• Automatic mapping from AS/400 to Oracle or MS SQL.
• All Oracle or MS SQL data types supported, including CHAR, NUMBER, and DATE.
• All AS/400 data types supported, including packed and zoned decimal.

Database Administration Facilities

• Complete site autonomy.
• Access control on a per-user basis.
• No need to duplicate AS/400 data definitions in Oracle or MS SQL.

SQL Language

• Uses ANSI/ISO standard SQL.
• Provides Oracle or MS SQLdata dictionary views of foreign data.
• Supports most Oracle or MS SQL Data Manipulation Language (DML) SQL extensions.
• Oracle or MS SQL stored procedures and packages.