|
Problem IC65612
|
Status: Closed |
DB2LOOK CORE DUMPS WHEN TRYING TO GENERATE DDL FOR OBJECTS WHICH HAVE MORE THAN 90 PARAMETERS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V9.5 users who use db2look for stored procedures with *
* more than 90 params. *
****************************************************************
* PROBLEM DESCRIPTION: *
* 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. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 V9.5 FP6, where the fix for this issue is *
* available. This APAR will make sure db2look doesn't core *
* dump, but results in an error instead. I you want db2look to *
* be able to generate DDL for stored procs which have more *
* than 90 params, you will need to apply DB2 V9.5 FP6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
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. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.01.2010
14.05.2010
14.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.,
9.5.FP6,
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
