DB2 - Problembeschreibung
Problem IC66510 | Status: Geschlossen |
DB2LOOK CURRENTLY DOES NOT GENERATE DDL FOR STORED PROCEDURES WH ICH HAVE MORETHAN 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. This is the current limitation of db2look, it can generate DDL only for stored procedure having maximum of 90 parameter list. Stored Procedures can support up to 32756 parameters which is considerable more in order to hold this info in the buffer. This APAR will address this issue by allowing db2look to handle a large parametered SP, especially more than 90 parameters. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 V9.1 users * **************************************************************** * PROBLEM DESCRIPTION: * * When customers run db2look it generates DDL for stored * * procedures which have upto 90 parameters. It fails to * * generate for the ones which are more than 90 parameters. * **************************************************************** * RECOMMENDATION: * * This APAR is first fixed in DB2 V9.1 FP10. Upgrade to DB2 * * v9.1 FP10 to get a fix for this APAR. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
This APAR will address this issue by allowing db2look to handle a large parametered SP, especially more than 90 parameters. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66511 IC66512 IC66513 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.02.2010 13.06.2011 13.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.0., 9.1.FP10 | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |