|Oracle Migration Workbench Reference Guide for IBM DB2/400 V4R5 Migrations
Release 9.2.0 for Microsoft Windows 98/2000 and Microsoft Windows NT
Part Number A97252-01
This chapter introduces the Oracle Migration Workbench (Migration Workbench). It includes information on the following:
The Migration Workbench is a tool that simplifies the migration of data and applications from an IBM DB2/400 V4R5 environment to an Oracle8, Oracle8i, or Oracle Appliance destination database. The Oracle RDBMS is a modern, scalable, high performance database server that can run on a wide range of computers from PCs to mainframes. Oracle operates in a networked, client/server environment. It can support tens, hundreds, or thousands of users, depending on the server.
The Migration Workbench allows you to migrate an entire application system and database schema in an integrated, visual environment.
The Migration Workbench provides an intuitive and informative user interface and a series of wizards to simplify the migration process. To ensure portability, all components of the Migration Workbench are written in Java.
The Migration Workbench uses a repository to store migration information. The repository allows you to query the initial state of the application before migration. By initially loading the components of the application system that you want to migrate into a repository, you can work independently of the production application.
Furthermore, the Migration Workbench uses a repository to store migration information about the components you are converting. You can use this information to understand the effect of modifying a given table.
Using the Migration Workbench you can:
IBM DB2/400 V4R5 is a relational database management system (RDBMS). IBM offers DB2 products on a number of platforms, including OS/390, AS/400, and UNIX-based systems. The Migration Workbench DB2/400 plug-in is a migration tool for Version 4 Release 3 of DB2 on the AS/400 system, (IBM DB2/400 V4R5), which is no longer supported by IBM.
The IBM DB2/400 V4R5 database is integrated with the AS/400 operating system, OS/400. It includes the following features:
The database uses SQL/400 as its native interface. SQL/400 includes non-SQL standard facilities such as Command Language (CL) and Data Description Specifications (DDS). These facilities originated with the IBM System/38 and existed before SQL became standard.