| Latest versions | 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 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC66766 | Status: Closed |
db2look receives segmentation fault if COMMENT statement is created on a stored procedure having more than 70 parameters. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * 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). | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
| Solution | |
this has been fixed in v97 fp2 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.03.2010 25.05.2010 25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.2, 9.7.FP2 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.2 |
|