| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC66766 | Status: Geschlossen |
db2look receives segmentation fault if COMMENT statement is created on a stored procedure having more than 70 parameters. | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
db2look receives segmentation if it tries to generate a DDL for stored procedure with more than 70 parameters and comment. The following steps illustrate one of the scenario. 1. Create a procesure with 80 parameters, then add a comment on the procedure. $ db2 connect to sample $ db2 "create procesure P80 (in p1 smallint, ...<params>..., in p80 smallint) language sql begin end" $ db2 "comment on P80 is 'aaaa'" 2. Run db2look with -e option. $ db2look -d sample -e -o db2look.out -- No userid was specified, db2look tries to use Environment variable USER -- USER is: DB2INST1 -- Creating DDL for table(s) -- Output is sent to file: db2look.out Segmentation fault(coredump) The stack trace shows strcmp() refers invalid address passed by create_comment_ddl(). (dbx) where strcmp.strcmp() at 0x100069c88 create_comment_ddl(char*,char*,char*,char*,char,int,FILE*,int,sq lca*)(??, ??, ??, ??, ??, ??, ??, ??) at 0x100022410 create_stored_procedure_ddl(int,char*,int,char*,int,int,char,int ,FILE*,int,sqlca*)(??, ??, ??, ??, ??, ??, ??, ??) at 0x100044668 create_ddl(int*,int*,int,int)(??, ??, ??, ??) at 0x100007f94 main(??, ??) at 0x100001f74 | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * software * **************************************************************** * PROBLEM DESCRIPTION: * * db2look was giving segmentation fault for parameter more * * than 70 * **************************************************************** * RECOMMENDATION: * * upgrade to v9.7.2 * **************************************************************** | |
| Local-Fix: | |
Please remove comment on the stored procesure(s). | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
| Lösung | |
this has been fixed in v97 fp2 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.03.2010 25.05.2010 25.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.2, 9.7.FP2 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.2 |
|