home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC95337 Status: Closed

DB2 CLP DUMPS CORE WITH OPTION -L AND STATEMENTS BIGGER THAN 128K

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
db2 clp dumps core with option -l and statements in the input 
file (-f) that are bigger than 128 k. 
 
Stack in the core would look like this: 
 
Program terminated with signal 11, Segmentation fault. 
#0  0x00002aaaab2ac19a in clpfp_install_signals(void (*)(int, 
siginfo*, void*), void (*)(int, siginfo*, void*)) () 
   from /home/xyz/sqllib/lib/libdb2.so.1 
(gdb) where 
#0  0x00002aaaab2ac19a in clpfp_install_signals(void (*)(int, 
siginfo*, void*), void (*)(int, siginfo*, void*)) () 
   from /home/xyz/sqllib/lib/libdb2.so.1 
#1  0x00002aaaab643df7 in clp_fp_sig_termpgm(int, siginfo*, 
void*) () from /home/xyz/sqllib/lib/libdb2.so.1 
#2  <signal handler called> 
#3  0x00002aaaab2a6ebd in clp_print_history(int, char*, sqlca*) 
() from /home/xyz/sqllib/lib/libdb2.so.1 
#4  0x00002aaaab2afd39 in clp_execmd() () from 
/home/xyz/sqllib/lib/libdb2.so.1 
#5  0x00002aaaab2ad4c6 in clp_execinp(int, int) () from 
/home/xyz/sqllib/lib/libdb2.so.1 
#6  0x00002aaaab2ac442 in clp_fp_con(int, int, char**) () from 
/home/xyz/sqllib/lib/libdb2.so.1 
#7  0x00002aaaab2a8138 in clp_api () from 
/home/xyz/sqllib/lib/libdb2.so.1 
#8  0x0000000000401f23 in main () 
 
In many cases you would not see a valid stack as it is 
overwritten with the statement text, eg: 
 
Core was generated by `end if; 
                end if; 
             end if; 
 
             set v_endtab'. 
Program terminated with signal 11, Segmentation fault. 
#0  0x00000032a8860d67 in gets () from /lib64/libc.so.6 
 
In this case a db2trc will help to identify the issue.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************
Local Fix:
run command without -l option
available fix packs:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
Problem Fixed In 10.5.0.3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.08.2013
04.03.2014
04.03.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.3 FixList
10.5.0.3 FixList