|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 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).
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.
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.
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: