DB2 - Problembeschreibung
Problem IC65612 | Status: Geschlossen |
DB2LOOK CORE DUMPS WHEN TRYING TO GENERATE DDL FOR OBJECTS WHICH HAVE MORE THAN 90 PARAMETERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - 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: * * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
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 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.01.2010 14.05.2010 14.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.0., 9.5.FP6, 9.5.FP6 | |
Problem behoben lt. FixList in der Version |