|
Problem IC66512
|
Status: Geschlossen |
DB2LOOK WILL GENERATE DDL FOR STORED PROCEDURES WHICH HAVE MORE THAN 90 PARAMETERS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 V97 users who want o run db2look to generate DDLs for *
* stored procs with more than 90 params. *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2LOOK WILL GENERATE DDL FOR STORED PROCEDURES WHICH HAVE *
* MORE THAN 90 PARAMETERS *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 FP2 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First Fixed in DB2 Version 9.7 fix pack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.02.2010
25.05.2010
30.08.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
