|
Problem IC87156
|
Status: Closed |
Application may see error SQL301N or SQL30020N, if a SQL/PL is created with array type. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 DB2 Version 9.7 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Version 9.7 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC92079 IC92081
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.10.2012
02.05.2013
02.05.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
