DB2 - Problembeschreibung
Problem IC65471 | 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 / 950 - 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: * * Users who use db2look tool. * **************************************************************** * PROBLEM DESCRIPTION: * * db2look receives segmentation if it tries to generate a * * DDLfor stored procedure with more than 70 parameters * * andcomment.The following steps illustrate one of the * * scenario.1. Create a procesure with 80 parameters, then add * * a commenton 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 Environmentvariable USER-- USER is: DB2INST1-- Creating * * DDL for table(s)-- Output is sent to file: * * db2look.outSegmentation fault(coredump)The stack trace shows * * strcmp() refers invalid address passedby * * create_comment_ddl().(dbx) * * wherestrcmp.strcmpcreate_comment_ddlcreate_stored_procedure_dd **************************************************************** * RECOMMENDATION: * * Please upgrade to version 9.5 fixpack 6 or later. * **************************************************************** | |
Local-Fix: | |
Please remove comment on the stored procesure(s). | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66766 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.01.2010 09.09.2010 09.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |