DB2 FOR LUW / DB2FORLUW / 950 - DB2

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

**************************************************************** 
* 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.            * 
****************************************************************

Please remove comment on the stored procesure(s).

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
 

Problem was first fixed in Version 9.5 Fix Pack 6.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC66766 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.01.2010
09.09.2010
09.09.2010

9.5.FP6