Skip Headers

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
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

4
Troubleshooting

This chapter provides troubleshooting solutions, information on offline data loading, and information on avoiding connection issues from the Migration Workbench to the IBM DB2/400 V4R5 database (AS/400 server).

Connecting to the IBM DB2/400 V4R5 Database

Using the Migration Workbench capture Wizard you should connect to the IBM DB2/400 V4R5 database as a user with DBA privileges. It is recommended to log on as QSECOFR, as this user has total control over all aspects of the database. The Migration Workbench will attempt to FTP add-in programs to the AS/400 source system, in order to capture data relevant to the database which cannot be sourced in the database catalog. Therefore, the user you log on as will need write and read privileges for the AS/400 machine.

Support for DBCS Data

This version of the Migration Workbench does not support the migration of databases containing DBCS data. The Migration Workbench appears to freeze or quit prematurely if it encounters DBCS data.

Offline Data Loading

A fast method of migrating data is to use the offline data loading facility. Using the Migration Workbench, the user can automatically create extraction scripts to export the IBM DB2/400 V4R5 database data into flat text files as well as SQL*Loader scripts. These are used to pump the IBM DB2/400 V4R5 flat file data into an Oracle database. This method of migration is considerably faster than via the Migration Workbench UI. In order to complete a successful migration using this method, the user should take note of the following:


Go to previous page Go to next page
Oracle
Copyright © 1998, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback