DB2 - Problembeschreibung
Problem IC65081 | Status: Geschlossen |
DB2LOOK CORE DUMPS WHEN TRYING TO GENERATE DDL FOR OBJECTS WHICH HAVE MORE THAN 90 PARAMETERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows | |
Lösung | |
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. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
First fixed in Db2 V9.1 FP 9 | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65612 IC65613 IZ68271 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.12.2009 29.04.2010 29.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.0., 9.1.FP9 | |
Problem behoben lt. FixList in der Version | |
9.1.0.9 |