DB2 - Problem description
Problem IC66171 | Status: Closed |
CREATING A PACKAGE WHEN CONECTING FROM ISERIES TO A DB2 LUW DATABASE FAILS WITH MESSAGE SQL9004 | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
When connected to a DB2 for Linux, Unix and Windows database V9.7 FP1, the iSeries client gets the error message SQL9004 ("Create of SQL package failed."). DDM trace of this scenario shows that the attempt to create a package failed because of a DRDA protocol error (sqlcode -30020) detected by the iSeries client while it was parsing the reply received from the DB2 LUW server. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 v9.1 iSeries client users * **************************************************************** * PROBLEM DESCRIPTION: * * When connected to a DB2 for Linux, Unix or Windows database * * at version DB2 v9.1, the iSeries client may receive the * * error message SQL9004 ("Create of SQL package failed."). * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.1 FP 10 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Solution | |
In this scenario there is an attempt to create a package that failed because of a DRDA protocol error (sqlcode -30020) detected by the iSeries client while it was parsing the reply received from the DB2 LUW server. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.02.2010 28.06.2011 28.06.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.10 |