1
Overview

This chapter introduces the Oracle Migration Workbench (Migration Workbench). It includes information on the following:

• Introduction to the Migration Workbench
  
  
• Introduction to IBM DB2/400 V4R5

Introduction to the Migration Workbench

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:

• Make a complete data migration from IBM DB2/400 V4R5 to Oracle8 or Oracle8i
  
  
• Migrate users, tables, table aliases, primary keys, foreign keys, unique constraints, indexes, views, and table-level privileges to Oracle8 or Oracle8i
  
  
• Generate the Oracle SQL*Loader and IBM DB2/400 V4R5 flat files for offline data loading
  
  
• Display a representation of the source database and its Oracle equivalent
  
  
• Generate a summary report of the migration
  
  
• Customize users, tables, indexes, and tablespaces
  
  
• Customize the default data type mapping rules
  
  
• Create ANSI-compliant names
  
  
• Automatically resolve conflicts, such as Oracle reserved words
  
  
• Remove and rename objects in the Oracle Model

Introduction to IBM DB2/400 V4R5

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:

• Referential Integrity
  
  
• Triggers
  
  
• Stored Procedures
  
  
• Two-Phase Commitment Control
  
  
• Distributed Relational Database Access (DRDA) Level 2

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.