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: