home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC91452 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************
Local-Fix:
run command without -l option
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 9.7 Fix Pack 9.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC91453 IC92517 IC95337 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.04.2013
17.12.2013
17.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList