Knowledge Base knowledge-base:database-migration:setup-and-troubleshooting:db2-as400
https://support.ispirer.com/
2026-05-12T18:08:14+0000Knowledge Base
https://support.ispirer.com/
https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.icotext/html2025-06-03T15:32:42+0000Anonymous (anonymous@undisclosed.example.com)IBM DB2 AS/400 (iSeries): Advanced Options
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/advanced-options?rev=1748964762&do=diff
Ispirer Website
Ispirer Toolkit Overview
Free Trial
IBM DB2 AS/400 (iSeries): Advanced Options
To open some additional options for target database at the “Target Options” page of SQLWays you can press on button “Advanced”:
----------
Common Options
Use Full Path To BIN Directory
If checked, the full path to native db2.exe utility for command will be generate by SQLWays tool.text/html2025-08-06T14:57:19+0000Anonymous (anonymous@undisclosed.example.com)Convert Logical Files from DB2 AS/400
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/file-conversion?rev=1754492239&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
Convert Logical Files from DB2 AS/400
DDS (Data Description Specifications) is a specification language used to describe the structure of tables, indexes, and views. It was introduced in early versions of DB2 for AS/400, prior to full support for SQL DDL.
In older versions of DB2 for AS/400 (up to approximatelytext/html2023-10-24T19:08:53+0000Anonymous (anonymous@undisclosed.example.com)How to Extract Logical and Physical Files from DB2 iSeries (AS/400)
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/file-extraction?rev=1698174533&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
How to Extract Logical and Physical Files from DB2 iSeries (AS/400)
This article explains how to extract DDS (Data Definition Structure) for Logical files from DB2 iSeries (AS400) database.
DDS information can be extracted by copying the MBR files from server or compiling the logical files. Below you can find a step by step guide on how it can be done.text/html2025-08-07T06:56:13+0000Anonymous (anonymous@undisclosed.example.com)Import Character Data Set as FOR BIT DATA
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/for-bit-data-import?rev=1754549773&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
Import Character Data Set as FOR BIT DATA
Symptoms
During the data import process in SQLWays, codes are extracted instead of actual values.
Cause
When columns are specified as for binary data, codes will be extracted instead of actual values.text/html2025-06-03T15:32:41+0000Anonymous (anonymous@undisclosed.example.com)Convert Multi-Member Tables from DB2 AS/400
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/multi-member-table-conversion?rev=1748964761&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
Convert Multi-Member Tables from DB2 AS/400
To convert Multi-Member Tables from DB2 iSeries using the Ispirer SQLWays we need to follow the steps described in this article.
Create Aliases on Members
First of all we need to identify the list of members created on a specific table. And then create aliases for each member, using the query:text/html2023-10-24T18:51:31+0000Anonymous (anonymous@undisclosed.example.com)Which DB2 AS/400 Client to Use For ODBC Connection Tuning
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/odbc-driver-choice?rev=1698173491&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
Which DB2 AS/400 Client to Use For ODBC Connection Tuning
When trying to tune the ODBC connection to DB2 AS/400 you may have some doubts regarding which DB2 Client to choose. According to the IBM documentation, you can use two tools to connect to DB2 AS/400:text/html2025-06-03T15:32:41+0000Anonymous (anonymous@undisclosed.example.com)IBM DB2 AS/400 (iSeries): ODBC Connection Tuning
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/odbc-driver-configuration?rev=1748964761&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
IBM DB2 AS/400 (iSeries): ODBC Connection Tuning
For DB2 Mainframe
The tuning of ODBC Connection to DB2 AS400 could be done in 2 ways:
* Using DB2 Connect Personal Edition
* Using ODBC Data Source Administrator
Using DB2 Connect Personal Editiontext/html2023-10-24T18:57:21+0000Anonymous (anonymous@undisclosed.example.com)SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *FIRST in *N type *MEM Not Found
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/sql-error-code?rev=1698173841&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *FIRST in *N type *MEM Not Found
Symptoms
When exporting data from AS/400 DB2 database the “SQL0204 - *FIRST in *N type *MEM not found” error is returned.
Cause
The object is not valid for the operation in the database. One possible reason is that the AS/400 file (table in terms of SQL) does not have any members.text/html2023-10-24T19:01:25+0000Anonymous (anonymous@undisclosed.example.com)SQL5016 - Qualified Object Name Not Valid
https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400/sql5016-not-valid?rev=1698174085&do=diff
Ispirer Website
Ispirer Capabilities: DB2 Migration
Free Trial
SQL5016 - Qualified Object Name Not Valid
Symptoms
During the export process from DB2 database you can see error “Failed (93 msec) [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL5016 - Qualified object name [Object_Name] not valid.” or