DB2 FOR LUW / DB2FORLUW / A10 - DB2

Running db2look on a database that has 
DB2_COMPATIBILITY_VECTOR=ORA set could fail with an SQL1131N 
error. 
 
For example: 
 
ALTER MODULE moo PUBLISH FUNCTION fprot (r1 INT) 
RETURNS int@ 
 
ALTER MODULE moo ADD FUNCTION fprot (r1 INT) 
RETURNS int 
BEGIN 
   RETURN r1-1; 
END 
@ 
 
"db2look -d dbname -e -mod -ct" will fail with -1131. 
 
An SQL1131N error implies that a stored procedure abended.   The 
db2look utility will invoke an internal DB2 stored procedure 
that abends.  When it does abend it can produce a trap file in 
the DIAGPATH directory that contains the following call stack: 
 
 
Stack of db2fmp trap: 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002AAAADA44A45 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x0385 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAADA4464C ossDumpStackTraceV98 + 0x002c 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAADA3F74D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00fd 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAABB9D41F sqlo_trce + 0x03ef 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAABB9E19E sqlo_dari_trca + 0x00ae 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAADF81D60 address: 0x00002AAAADF81D60 ; dladdress: 
0x00002AAAADF74000 ; offset in lib: 0x000000000000DD60 ; 
        (/lib64/libpthread.so.0) 
0x00002AAAAE530109 _IO_vfprintf + 0x0049 
        (/lib64/libc.so.6) 
0x00002AAAAE539468 fprintf + 0x0088 
        (/lib64/libc.so.6) 
0x00002AAAB2B28163 
_Z24create_routine_prototypePcS_iiiS_iS_ciP8_IO_FILEiP5sqlca + 
0x0b93 
        (/home/hotellnx92/db2inst1/sqllib/bin/routine/db2lkfun) 
0x00002AAAB2B26E76 
_Z17create_module_ddliPciiS_iiiciP8_IO_FILEiiP5sqlca + 0x0d06 
        (/home/hotellnx92/db2inst1/sqllib/bin/routine/db2lkfun) 
0x00002AAAB2B109AF db2look_generate_ddl + 0x139f 
        (/home/hotellnx92/db2inst1/sqllib/bin/routine/db2lkfun) 
0x00002AAAAB295B59 sqloInvokeFnArgs + 0x7009 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB9859F1 address: 0x00002AAAAB9859F1 ; dladdress: 
0x00002AAAAABC7000 ; offset in lib: 0x0000000000DBE9F1 ; 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB98553C sqlerDyload + 0x014c 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB97B4F7 sqlerFmpListener + 0x0be7 
        (/home/hotellnx92/db2inst1/sqllib/lib64/libdb2.so.1) 
0x0000000000402DC6 main + 0x0bf6 
        (db2fmp () 
0x00002AAAAE50C304 __libc_start_main + 0x00f4 
        (/lib64/libc.so.6) 
0x0000000000402139 _ZNSt8ios_base4InitD1Ev + 0x0039 
        (db2fmp () 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1, Fixpack 5                       * 
****************************************************************

n/a

First fixed in DB2 Version 10.1, Fixpack 5

not known / see Local fix

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

21.03.2014
14.07.2015
14.07.2015