home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66511 Status: Geschlossen

DB2LOOK WILL GENERATE DDL FOR STORED PROCEDURES 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. 
 
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:                                              * 
* Users usingDB2 V9.5                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2LOOK WILL GENERATE DDL FOR STORED PROCEDURES WHICH        * 
* HAVEMORETHAN 90 PARAMETERS                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 V9.5 FP6                                           * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
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.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.02.2010
25.05.2010
25.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.,
9.5.FP6
Problem behoben lt. FixList in der Version