|
Problem IC92079
|
Status: Closed |
Application may see error SQL301N or SQL30020N, if a SQL/PL is created with array type. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
If a SQL/PL is created with array type and number of parameters
are more than 40, application may see error SQL301N or
SQL30020N.
In case of SQL30020N, ""INVALID FDOCA DESCRIPTOR" message may be
logged on client or server along with binary dumps.
MESSAGE : ZRC=0x8037008E=-2143879026=SQLJR_DSCINV "INVALID FDOCA
DESCRIPTOR"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml:
17
sqlerrmc: 0x220A"("0200")"
The fix is needed on both DB2 LUW client or driver and server.
If application is using DB2 JCC driver, fix is also needed on
JCC driver. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest level. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in V9.7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.05.2013
03.10.2013
03.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
