Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

How This Reference Guide is Organized

How to Use This Reference Guide

Documentation Accessibility

Accessibility of Code Examples in Documentation

Related Documentation

Conventions

1 Overview

Introduction to the Migration Workbench

Introduction to IBM DB2/400 V4R5

2 Oracle and IBM DB2/400 V4R5 Compared

Data Storage Concepts

Oracle Data Storage Concepts

IBM DB2/400 V4R5 Data Storage Concepts

IBM DB2/400 V4R5 File Types

IBM DB2/400 V4R5 Backup Facility

Schema Migration

Schema Object Similarities

Schema Object Names

Table Design Considerations

Schema Migration Limitations for IBM DB2/400 V4R5

Data Types

Data Types in Oracle and IBM DB2/400 V4R5

Character Strings

Graphic Strings

Numeric Types

Date Data Types

Database Security

IBM DB2/400 V4R5 Privilege System

Public Authority

Group Profiles and Authorization Lists

Object Ownership

3 Migration Process

IBM DB2/400 V4R5 Architecture

Oracle Architecture

PL/SQL Programming Language

Triggers and Stored Procedures

Sequences

Transactions

Other Oracle Features

Preparing for Migration

Extending the Application

Using Offline Data Loading

extract_nn Add-in

Script Directory Structure

Generating Extract Scripts

Using the Extract Scripts

4 Troubleshooting

Connecting to the IBM DB2/400 V4R5 Database

Support for DBCS Data

Offline Data Loading

Index