DB2 FOR LUW / DB2FORLUW / 910 - DB2

Db2look is using a buffer to hold the parameter list. The 
maximum number of parameters for Function and Method is 90 and 
hence we have allocated the buffer size according to it (the 
current array size allocated is 258 * 90 = 23220), where as in 
case of stored procedure the maximum number of parameters is 
2756  ( 258 * 32756 = 8451048 ).  This is huge in comparison of 
the parameter list supported for function, hence we treat the 
buffer size as a limitation for stored procedure. 
 
 
This is a limitation of db2look, it can generate only the stored 
procedure having a maximum of a 90 parameter list, as mentioned 
above. Stored Procedures can support up to 32756 parameters 
which is considerably more in order to hold this info in the 
buffer. 
 
NOTE: - This APAR will address this issue by throwing an error 
message instead of core dumping. This APAR will NOT allow 
DB2LOOK to generate a DDL for an object that has more than 90 
parameters.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on DB2 V9.1, V9.5 and V9.7                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2LOOK CORE DUMPS WHEN TRYING TO GENERATE DDL FOR OBJECTS   * 
* WHICH                                                        * 
* HAVE MORE THAN 90 PARAMETERS                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in Db2 V9.1 FP 9                                 * 
****************************************************************

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Db2look is using a buffer to hold the parameter list. The 
maximum number of parameters for Function and Method is 90 and 
hence we have allocated the buffer size according to it (the 
current array size allocated is 258 * 90 = 23220), where as in 
 
case of stored procedure the maximum number of parameters is 
2756  ( 258 * 32756 = 8451048 ).  This is huge in comparison of 
the parameter list supported for function, hence we treat the 
 
buffer size as a limitation for stored procedure. 
 
 
This is a limitation of db2look, it can generate only the 
 
stored 
procedure having a maximum of a 90 parameter list, as mentioned 
 
above. Stored Procedures can support up to 32756 parameters 
which is considerably more in order to hold this info in the 
buffer. 
 
NOTE: - This APAR will address this issue by throwing an error 
message instead of core dumping. This APAR will NOT allow 
DB2LOOK to generate a DDL for an object that has more than 90 
parameters.

not known / see Local fix

First fixed in Db2 V9.1 FP 9

forerunner  : APAR is sysrouted TO one or more of the following: IC65612 IC65613 IZ68271 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.12.2009
29.04.2010
29.04.2010

9.0.,
9.1.FP9