DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8.                       * 
****************************************************************

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
 

First fixed in Version 9.7 Fix Pack 8.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC92079 IC92081 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.10.2012
02.05.2013
02.05.2013

9.7.FP8